we're trying to install DS8 on Solaris using Oracle for the metadata. The installation fails giving the error:
(TestProject is the name we gave). In the other logfile we find java-traces which I don't understand.(May 26, 2008 5:47:24 PM), Install_datastage, com.ascential.acs.installer.server.actions.InstallDSProjectsAction, err, ProductException: (error code = 601; message="The following project was not created TestProjectView the log file for more details./prd/llb/sft/dtsadm/install/8.0.1/InformationServer/logs/datastage_install.log")
If we look in the database we get more meaningfull errors:ProductException: (error code = 601; message="The following project was not created TestProjectView the log file for more details./prd/llb/sft/dtsadm/install/8.0.1/InformationServer/logs/datastage_install.log")
at com.ascential.acs.installer.utils.ProductActionUtil.showUserMessage(ProductActionUtil.java:34)
at com.ascential.acs.installer.server.actions.InstallDSProjectsAction.addQuickProject(InstallDSProjectsAction.java:283)
at com.ascential.acs.installer.server.actions.InstallDSProjectsAction.install(InstallDSProjectsAction.java:194)
at com.installshield.product.service.product.PureJavaProductServiceImpl.installProductAction(PureJavaProductServiceImpl.java:2969)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.getResultForProductAction(PureJavaProductServiceImpl.java:8048)
at com.installshield.product.service.product.InstallableObjectVisitor.visitComponent(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitInstallableComponents(Unknown Source)
at com.installshield.product.service.product.InstallableObjectVisitor.visitProductBeans(Unknown Source)
at com.installshield.product.service.product.PureJavaProductServiceImpl$InstallProduct.install(PureJavaProductServiceImpl.java:7199)
at com.installshield.product.service.product.PureJavaProductServiceImpl$Installer.execute(PureJavaProductServiceImpl.java:5240)
at com.installshield.wizard.service.AsynchronousOperation.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
ORA-00001: unique constraint (XMETA.XMETALOCKINFO_PK) violated
INSERT INTO XMetaLockInfo (repository_id,locked_at,locked_by_user,locked_by_session,needs_upgrade) VALUES (:v0,:v1,:v2,:v3,:v4)
we get this multiple times.
The DB was completely empty before start of this install so this means that DS itself inserts duplicates.
One possible problem: in the install guide it says to create the xmeta user in oracle trough a template script that can be found in dbca\templates . We didn't have this script so we created a more standard user with a lot of possibilities.
Anybody had this same problem?
Does anybody have the create_xmeta_user.sql to create the user correctly?