Six Stars

Error while executing batch file

Hi,

 

I am getting error while loading the oracle as source and target is excel file.

when am executing batching RETURN_NULL_AND_BLANK error.

 

Please find the attached screen shot.

 

Thanks

Shree

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Error while executing batch file

Hello,

Please follow up these steps to setup routine dependencies on a job.

1.Right-click an existing Job, and select Setup routine dependencies from the contextual menu.

2. In the [Setup routine dependencies] dialog box, select the User routines tab and click the plus button to add a customized routine.

3. Click OK to confirm the selection.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
7 REPLIES
Moderator

Re: Error while executing batch file

Hi,

Can you successfully execute your job in studio? Did you use any user routine dependencies?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Error while executing batch file

Hi Sabira,

 

Yes, There are two routine am using.

 

Thanks

shree

Moderator

Re: Error while executing batch file

Hi,

Have you already selected "setup routines dependencies" for your user routine dependencies? Can you execute your job perfectly fine in studio?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Error while executing batch file

Hi Sabira,

 

May i know how to "setup routine dependencies".

 

Steps: 

1) Right click on job and select setup routine dependencies.

2) Select routine name and click ok.

 

The above steps are correct or any thing need to add?

 

Thanks

Shree

Moderator

Re: Error while executing batch file

Hello,

Please follow up these steps to setup routine dependencies on a job.

1.Right-click an existing Job, and select Setup routine dependencies from the contextual menu.

2. In the [Setup routine dependencies] dialog box, select the User routines tab and click the plus button to add a customized routine.

3. Click OK to confirm the selection.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Error while executing batch file

Thanks Sabira.

 

Regards

Shree

Moderator

Re: Error while executing batch file

Hi,

Thanks for your feedback. The solution "setup routine dependencies" right fix your executing batch file issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.