Failed to Open Project

sambitsamantray · Post by **sambitsamantray** » Mon Feb 20, 2012 11:08 am

Hello,

When i'm running jobs in datastage 8.7 Server edition, my jobs are aborting due to the below message.

ERROR: Failed to open project

Status code = 80147

The jobs are working fine in Datastage 7.5 version. I've recently migrated them to Datastage 8.7.

Is there anything which i'm missing out while installing the new version of datastage?

kandyshandy · Post by **kandyshandy** » Mon Feb 20, 2012 9:02 pm

If you are able to login & open/edit the job in Designer but this error during the run, i would contact support.

chulett · Post by **chulett** » Tue Feb 21, 2012 8:03 am

As would I... perhaps something needs to be tweaked in uvconfig?

sambitsamantray · Post by **sambitsamantray** » Tue Feb 21, 2012 1:23 pm

Thank you.

I've contacted support and they are currently working on this issue.

sambitsamantray · Post by **sambitsamantray** » Tue Feb 21, 2012 2:31 pm

Can you give me any details about changes to uvconfig file so that i can ahead and try that out and see if it works out for me?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 21, 2012 3:12 pm

Nothing in uvconfig will affect "fail to open project".

qt_ky · Post by **qt_ky** » Tue Feb 21, 2012 6:11 pm

Please share what you discover from working with support, in case it will help anyone else with the same error in the future.

chulett · Post by **chulett** » Tue Feb 21, 2012 6:55 pm

ray.wurlod wrote:Nothing in uvconfig will affect "fail to open project".

I know there are specific error messages that should also be reported, but wouldn't running out of certain resources also cause the 'fail to open project' message? I've got nothing to refer to and just working from memory, thinking about the maximum number of open hashed files or something of that nature.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 21, 2012 7:22 pm

OK, got me. But, presumably, the values post migration would be set to the pre-migration values.

qt_ky · Post by **qt_ky** » Tue Feb 21, 2012 8:27 pm

This 8.5 tech note may apply to 8.7 also... (no mention of uvconfig)

http://www-01.ibm.com/support/docview.w ... wg21449196

sambitsamantray · Post by **sambitsamantray** » Thu Feb 23, 2012 3:58 pm

Even IBM provided to refer to the same link but the resolution provided in the link seems a little bit strange. If the jobs are supposed to be executed with Windows Admin privileges, then everyone will have admin privileges.

qt_ky · Post by **qt_ky** » Thu Feb 23, 2012 5:45 pm

I'm not going argue with what IBM Support is telling you on this issue. Try it.

sambitsamantray · Post by **sambitsamantray** » Tue Feb 28, 2012 10:22 am

It'w working when we are having admin privileges but we got an update from the IBM support that they have identified a fix and they'll be providing us the patch to fix this issue.

sambitsamantray · Post by **sambitsamantray** » Thu Mar 08, 2012 2:00 pm

Got the patch from IBM, installing which all the issue has been fixed

Kryt0n · Post by **Kryt0n** » Thu Jul 05, 2012 6:27 pm

Any hints as to which patch has the fix?