topic Re: unable to open a particular job in SAS DI Studio in SAS Data Management

Unable to open a particular job in SAS DI Studio

Shakti_Sourav — Thu, 11 May 2023 05:25:47 GMT

Dear Team,

We are unable to open a particular job in SAS DI studio Production or live Environment, tried it to restore the job by back up file but it's not working in Production Env.

also we had tried to export the job package and Import again for restore the ETL Job but we failed.

Please suggest, what's the issue and how to resolve it asap.

We are getting the job opening in few seconds and then after immediately closed automatics.

If possible, can you share us the logs query or any path to find the issue ?

Thanks

Shakti

unable to open a particular job in SAS DI Studio

sathya66 — Thu, 25 Apr 2019 10:57:09 GMT

Hi,

I am unable to open a particular job in DI Studio. When I attempt to load it, DI Studio will load up a new window, work for a few seconds, and then exit without presenting an error message. The same happens when it is tried on other users computers. The issue does not effect any of the other jobs in this project.

I have tried exporting the job and then loading it in DI Studio, but the same issue still occurs. what is the issue with my job

Thanks,

Re: unable to open a particular job in SAS DI Studio

joeFurbee — Thu, 25 Apr 2019 12:13:04 GMT

Hi @sathya66,

We'll need some more information to help you debug. What transform is your job performing? Is it a job with many steps? Can you recover any logs from the crash after restart?

You may try setting checkpoints in you jobs where you think it may be failing. Here is a video on how to set and use checkpoints in DI.

Re: unable to open a particular job in SAS DI Studio

sathya66 — Thu, 25 Apr 2019 12:18:12 GMT

Hi,

thanks for your reply.

DI job is not opening when I double click on it.

When I attempt to open the DI job (double click on the job ), DI job will load up for a few seconds(trying to open ), and then exit the job (closing the job by itself).

Thanks,

Re: unable to open a particular job in SAS DI Studio

AllanBowe — Thu, 25 Apr 2019 13:29:18 GMT

Try increasing the memory on your client-
https://www.rawsas.com/improve-performance-of-di-studio-client/

The default is too low for large jobs

Re: unable to open a particular job in SAS DI Studio

Shakti_Sourav — Thu, 11 May 2023 05:19:12 GMT

Dear AllanBowe,

I am also getting same issue. Particular job not opening in Production Environments and Backup Job package also not working but when tried it on Development Environment, It's Working fine.

as well we have checked the memory. It's sufficient only 10% of memory used.

Please suggest, what's the issue and how to resolve it asap.

If possible, can you share the logs query or path to find the issue..

Thanks

Shakti

Re: Unable to open a particular job in SAS DI Studio

LinusH — Thu, 11 May 2023 07:57:05 GMT

The best way to get detailed help is to open a ticket to SAS tech support.

Be ready to supply metadata server logs, and DI Studio client logs.

Re: unable to open a particular job in SAS DI Studio

sathya66 — Thu, 11 May 2023 08:58:20 GMT

Hi,

We resolved this by creating the same job with different name. Your metadata might be corrupted and also memory settings didn't help us.

try below options

1. Delete your job and try importing that job from development

2. Create same job with different name(you would need to change all the jobname across other ENVs ).

Re: Unable to open a particular job in SAS DI Studio

ErikLund_Jensen — Mon, 22 May 2023 19:00:19 GMT

Hi @Shakti_Sourav

This happens now and then. In my experience, this particular behaviour is seen when a work table (or view) has one or more columns with empty names.

It is easy to fix if you have acces to the Metadata Browser found under Solutions -> Accssories in SAS Display Manager (also known as Base SAS).

Open the Metadata Browser and connect to the relevant Metatada Server
Make sure you have Brwese mode unchecked.
When the tree is displayed, right-click in the frame and select Find
Enter the search string Column?@Name=' '
If there are any columns without names, a list of objects is displayed.
For each column

- right click on it and select explore from here.

- in the right pane, right click on the Name attribute and select Modify

- enter a column name, just call then A, B C and so on.

Now the job should open, and you can open the transformations, locate the columns with names A, B, C and rename them.