Import routine from dsx file

maschiliro · Post by **maschiliro** » Thu May 07, 2009 5:06 am

Hi, who can help me on a problem I never had on previous release of data stage?
I've developed 3 routines and I saved them in a new folder PRJ inside Routines category. I Exported them in a dsx file (I tried with all options: source, object, both...). When I try to import them from this dsx file to a differente Repository I have a message like:
3 objects ignored....

Thanks, Mary

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 07, 2009 6:41 am

Read only ?

maschiliro · Post by **maschiliro** » Thu May 07, 2009 10:01 am

Sainath.Srinivasan wrote:Read only ?

I have tried the export with flag on and off but the result is not changed.
Thanks for the collaboration.

mfavero · Post by **mfavero** » Thu May 07, 2009 10:54 am

Are the routines marked read-only in the project you export from?

Do they already exist in the project you are importing to and are they read-only there?

inspect the dsx file and search for ROUTINE - are there other routines in the dsx besides the 3 you want?

maschiliro · Post by **maschiliro** » Thu May 07, 2009 11:38 am

mfavero wrote:Are the routines marked read-only in the project you export from?

How I can know if a routine is marked read-only?

Do they already exist in the project you are importing to and are they read-only there?

No. They not exist in in the project I am importing to.

inspect the dsx file and search for ROUTINE - are there other routines in the dsx besides the 3 you want?

No. There are only these 3 routines.

Thanks for the collaboration.

mfavero · Post by **mfavero** » Thu May 07, 2009 12:25 pm

You can see if a routine is read-only by double clicking on it in designer and at the top of the window it will show (Read-Only)

Also all the buttons are grey except Close and Help, so you cannot save or compile it.

If your routines are not read-only then it must be something in the new projects -maybe you are not set up as a developer in the Suite admin or the directory/file permissions for the project are goofy.

Have the dsadm try the import.

mfavero · Post by **mfavero** » Thu May 07, 2009 12:26 pm

You can see if a routine is read-only by double clicking on it in designer and at the top of the window it will show (Read-Only)

Also all the buttons are grey except Close and Help, so you cannot save or compile it.

If your routines are not read-only then it must be something in the new projects -maybe you are not set up as a developer in the Suite admin or the directory/file permissions for the project are goofy.

Have the dsadm try the import.

maschiliro · Post by **maschiliro** » Thu May 07, 2009 1:13 pm

mfavero wrote:You can see if a routine is read-only by double clicking on it in designer and at the top of the window it will show (Read-Only)

Also all the buttons are grey except Close and Help, so you cannot save or compile it.

If your routines are not read-only then it must be something in the new projects -maybe you are not set up as a developer in the Suite admin or the directory/file permissions for the project are goofy.

Have the dsadm try the import.

My routines are not read only (I can save and compile them).
I am dsadm when I try to import them.
I'll Check directory/file permissions ...

Any other suggestion?

Thanks

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Thu May 07, 2009 2:31 pm

Are you trying to load into a "protected" project?

chulett · Post by **chulett** » Thu May 07, 2009 2:43 pm

I've seen the same behaviour on a 7.5.1A server where it would sometimes just refuse to import routines if that was all that was in the export file. I don't remember if there was a resolution or not, I think what I ended up having to do was include at least one job in the mix. It definitely smelled of bug to me.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri May 08, 2009 4:40 am

In that case, you can append a job to the export and do a "import selected".

chulett · Post by **chulett** » Fri May 08, 2009 7:20 am

You can try that, but I think I had to actually import everything, job and all, to get the routines to come along for the ride. It's been awhile, so who knows. Let us know, if anything, works for you.

pandujoy · Post by **pandujoy** » Fri May 08, 2009 2:52 pm

i guess the dsx file is read only...

open the dsx file in a notepad and look for ReadOnly = '1'..if u see this replace it with Readonly'0'....n u will be good to go...

chulett · Post by **chulett** » Fri May 08, 2009 3:30 pm

Guess again.

campbellj2 · Post by **campbellj2** » Fri Aug 07, 2009 9:42 am

chulett wrote:Guess again.

I am having the same problem with Datastage 8.1 on Windows 2003. No routines will import in either DSX or XML format. IBM states that this is a known bug listed as APAR JR31756. The link with the details are under http://www-01.ibm.com/support/docview.w ... wg1JR31756
The notes say that there is a patch listed for this problem as patch # JR31326 which I cannot find in FixCentral. I am still waiting for a response from IBM.

DSXchange

Import routine from dsx file

Import routine from dsx file

Importing Routines Datastage 8.1