Sales RapidMart Initial Load Error

dataservices rapidmarts
1

Hello All,

The Initial Load on the DEV server failed with an error ‘Time Limit exceeded’ while executing the DF_SalesOrderStage_SAP dataflow. To resolve this I changed the ‘Execute in Background’ to Yes and executed the job, after which I get the below error message

4640 8220 R3C-150605 3/23/2013 7:04:52 AM |Data flow DF_LanguageEnable_SAP
4640 8220 R3C-150605 3/23/2013 7:04:52 AM The SAP job was canceled for host < >, job name <R3_LanguageEnable 03/23/13 07:04:37>, job count <07043700>, job log from SAP <
4640 8220 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Job started
4640 8220 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Step 001 started (program ZW04640001, variant &0000000000000, user ID BIADMIN01)
4640 8220 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Error at OPEN ‘F:\usr\sap\DEV\SYS\global\ftproot/LangEnable.dat’ (check file)
4640 8220 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Job cancelled after system exception ERROR_MESSAGE
4640 8220 R3C-150605 3/23/2013 7:04:52 AM >.
9964 9384 R3C-150605 3/23/2013 7:04:52 AM |Data flow DF_LanguageEnable_SAP
9964 9384 R3C-150605 3/23/2013 7:04:52 AM The SAP job was canceled for host < >, job name <R3_LanguageEnable 03/23/13 07:04:37>, job count <07043700>, job log from SAP <
9964 9384 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Job started
9964 9384 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Step 001 started (program ZW04640001, variant &0000000000000, user ID BIADMIN01)
9964 9384 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Error at OPEN ‘F:\usr\sap\DEV\SYS\global\ftproot/LangEnable.dat’ (check file)
9964 9384 R3C-150605 3/23/2013 7:04:52 AM 23.03.2013 07:04:37 Job cancelled after system exception ERROR_MESSAGE
9964 9384 R3C-150605 3/23/2013 7:04:52 AM >.

I do not get this error message if I change the ‘Execute in Background’ to No . The ‘Working Directory on SAP server’ is set to ‘F:\usr\sap\DEV\SYS\global\ftproot’ and the ‘FTP host Working Directory’ is ‘.’

I manually logged in to SAP server using FTP and can see the LangEnable.dat file there, tried to run the Job after deleting the LangEnable.dat file still the same error.

Any help on this is appreciated

Thank You
Ranjit

ranjit.krishnan (BOB member since 2008-11-11)

2

The error in SAP that occurs has nothing to do with running in the background yes or no. In fact, you mentioned that with running in foreground you did not have the error: that is not correct. Probably the job did not reacht the point of writing to a flat file.

This error normally means that the SAP server cannot write to the local directory. This normally is a rights issue either with the authorization role (SAP User not allowed to write to that dir) or the SAP sys user not allowed to write to that dir.

However, as you said, the file was created.

There are some peculair things:
‘F:\usr\sap\DEV\SYS\global\ftproot’
Is your SAP server running on Windows? And you are writing the file directly to the FTP root instead of a sub directory? Why not use a UNC path as that is ‘safer’ than a drive mapped to a letter?

‘F:\usr\sap\DEV\SYS\global\ftproot/LangEnable.dat’
Is listed in the BODS errors (look at the slashed and dashes). Try to set the local directory to / instead of \ ?

Johannes Vink :netherlands: (BOB member since 2012-03-20)