Scripts in SAP BODS 4.0

dataservices job design
1

Hi Everybody,

Can i use Scripts as is in SAP BODS 4.0?
Recentaly we have installed new version of SAP BODS 4.0 from SAP BODS 3.1. We have migrated all the related jobs, datastores and all the related stuff.

When i try to validate one job in new version then at scripts, i was getting an error on using SQL() functions.

While working on the function in scripts, do we need follow any procedure?
Please let me know.

Thanks,
Mohammed.

sheikaba (BOB member since 2007-12-06)

2

Just to reiterate my above question. How to use sql() function while writing scripts in BODS 4.0

sheikaba (BOB member since 2007-12-06)

3

Post us on what error you get?

ganeshxp :us: (BOB member since 2008-07-17)

4

Here is the attached error screen shot.

Thanks,
Abdulrasheed.

sheikaba (BOB member since 2007-12-06)

5

Believe the screenshot is not attached…

ganeshxp :us: (BOB member since 2008-07-17)

6

Sorry… i have tried but not able to attached the screen shot.
Here is the error i m getting.

[Script:SCPT_UPDATE]
The script <SCPT_UPDATE> contains an invalid expression. Additional information: <Function was not found in the repository. Before use, a script function must be created, and a non-script function must be imported.>. (BODI-1111242)

Regards,
Abdulrasheed

sheikaba (BOB member since 2007-12-06)

7

Any update on the above issue please?

sheikaba (BOB member since 2007-12-06)

8

Can you do post the script ? Wonder what went wrong? Is the same script work fine in any other repository?

ganeshxp :us: (BOB member since 2008-07-17)

9

Hi Ganesh,

For me, it seems that it’s not an issue with query or the syntax of the query or the function we are using. but the problem is with the functions usage in SAP BODS 4.0.

Why becuase when i validate my box at the JOB level, then i got few error and each error was getting at the usage of function like sql() is one and ifthenelse, decode and all the other fucntions.

Now the issue is how to make use of the functions in SAP BODS 4.0. Simply we can’t even create a function and to use it in the job implementation. For example if i have imported one previous version job into new version like BODS 4.0 then i can’t create all the functions in 4.0.

There should be a quick turn around for this issue. Please help us on this.

For your reference, this is the below query i am using in the Script.

sql(‘DS_ODS3_TARGET’,‘update ODS_CLAIM_STATUS_DIM set current_flag = ‘n’ where current_flag is null’);

Regards,
Abdulrasheed.

sheikaba (BOB member since 2007-12-06)

10

I then feel like the repository creation is corrupted or some sort of privileges you miss in using that Database or the DSConfig file is corrupted.

ganeshxp :us: (BOB member since 2008-07-17)

11

Can you please create a new job with just one script and that contains the sql() function of yours?

I want to validate if there is a problem with the escape chars ‘n’ in DS 4.0 as such or if the repo upgrade/import had a problem.

Werner Daehn :de: (BOB member since 2004-12-17)

12

Thanks to all for your inputs.

Just to update, now the issue got resolved.
Actually there one repo_functioninfo.atl file was missed file installing BODS4.0. Now we got that file from the admin folder and placed it.

Now we are able to validate the job and able to run it as well.

Regards,
Abdulrasheed.

sheikaba (BOB member since 2007-12-06)