Hi,
I'm trying to import a deployment package archive into Contributor but it is terminating as "FAILED".
The error mesage displayed on screen is:
"Unable to import application 'datastores/<DB>/applications/<app_name>' - the application may be corrupted, you should restore it from a database backup."
This occurs on all my application within the package.
I have validate that all application display names don't contain a backslash, and everything is fine.
Anyone have a clue why this is appening ?
Hi Stephane,
As a test, try cutting the users.txt file from the security folder (I believe) and try running the import again. If this works, you will need to export the rights for each application from our source environment and import into the target environment.
Hi,
I already remove the users.txt from both "security" and <application> folders and still no luck...
I have had this error twice. Once we resolved it by removing users.txt as was suggested. The other time I ended up where you after having tried the users.txt solution. After trying everything I ended up rebooting the servers and then it worked without a hitch.
Maybe try rebooting and see if the behaviour changes. The other question I have is about the import. Are you bringing this import into a new environment or overwriting an existing application?
Hi Eric,
I just reboot the server and it still cannot import.
For your question, I'm importing into a brand new environment.
Tx
Stephane,
Can you give a bit more background? What is the source environment and what is the new environment? Are they different versions? Have you been able to import other packages? Are the database environments the same? Anything along those lines that you can provide would be helpful.
Is this an upgrade or simply a deployment?
Jeff
Hi Jeff,
Basically, I'm exporting from a C10.1 PROD environment and importing back (trying to) a C10.1 DEV environment and I compared cmplst.txt files and both are exactly the same.
I'm not able to import any applications.
For the DB part, I'm trying to import into a brand new Oracle DB schema and I had validated that both Oracle versions are the same as well :).
I also tryed to delete all LOB files and to rename extension.xml files as *.bak in all application folders within the import package but still no luck.
I validate that my new schema has proper previleges & roles as per the following list:
---
select * from session_privs order by 1;
/* returns:
PRIVILEGE
----------------------------------------
ADMINISTER RESOURCE MANAGER
ALTER ANY PROCEDURE
ALTER ANY SEQUENCE
ALTER ANY TABLE
ALTER ANY TRIGGER
BACKUP ANY TABLE
CREATE ANY INDEX
CREATE ANY SEQUENCE
CREATE ANY SYNONYM
CREATE ANY TABLE
CREATE ANY TRIGGER
CREATE ANY VIEW
CREATE CLUSTER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
DELETE ANY TABLE
DROP ANY PROCEDURE
DROP ANY SEQUENCE
DROP ANY TABLE
DROP ANY INDEX
DROP ANY TRIGGER
DROP ANY VIEW
DROP USER
EXECUTE ANY PROCEDURE
EXECUTE ANY TYPE
INSERT ANY TABLE
READ ANY FILE GROUP
RESUMABLE
SELECT ANY SEQUENCE
SELECT ANY TABLE
UNLIMITED TABLESPACE
UPDATE ANY TABLE
*/
select * from session_roles;
/* returns:
ROLE
------------------------------
CONNECT
RESOURCE
EXP_FULL_DATABASE
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
EXECUTE_CATALOG_ROLE
*/
---
Stephane,
I have not worked with 10.1, yet, but here's something from IBM's site, if this helps:
http://publib.boulder.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.contrib_admin.10.1.0.doc%2Fcontrib_admin_id20068contr_LimitsImprtPkgs.html
IBM Cognos Package Security
Only IBM Cognos Packages with an assigned database signon can be used with IBM Cognos Planning since no log-on dialog box is displayed during import.
Are there any planningerrorlog.csv files on the Development environment under either your profile or the service account?
Jeff
Hi Jeff,
It seems that I have a connection problem with the DB but can't figure why and the Cognoise system don't let me attach a file...
Any help will be welcome.
Are you able to connect to the DB using SQL Plus from the DEV server? It would be good to pinpoint if it an Oracle client issue or a Cognos issue that is affecting you. Also, are there any differences in privileges between the users on Prod and Dev? I know you did the check list above but are the accounts exactly the same? If you were to add DBA role temporarily would it work?
Just some thoughts...I hope it moves you in a positive direction.
Hey Stephane,
I don't see it suggested yet, but have you tried creating a test application in the development environment? This would be the most logical test of the connection to the DB as well as the privs. required to create / update an application user / schema. If this does work, then it's likely something specific to the deployment itself. I've seen issues that were isolated to applications that were upgraded / migrated and you might want to try exporting from prod again.
Things to try:
- create sample application (go_capex or the like) or, using a business specific model, create a new application in development.
- try re-deploying from production again (on the package selection screen for the deployment wizard in development, scroll to the right and make note of the last column.. should say import)
- if the re-deploy doesn't work, try creating a sample application in PROD and export that using the deployment wizard and try to import into Dev. (this is to rule out a problem with the existing production applications by using a sample 'known good' app.
Also:
- What is the exact install kit and build of planning that's being used? (in the CAC, under help, about, please click the 3 dots to the bottom right and return ALL of the values)
Still not sure what the problem is, but maybe something above will help narrow it down...