Unable to import a deployement package into Contributor

[Stephane Lambert]

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 ?

[ericlfg]

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.

[Stephane Lambert]

Hi,

I already remove the users.txt from both "security" and <application> folders and still no luck...

[Danno]

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?

[Stephane Lambert]

Hi Eric,

I just reboot the server and it still cannot import.

For your question, I'm importing into a brand new environment.

Tx

[jeffowentn]

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

[Stephane Lambert]

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
*/
---

[jeffowentn]

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

[Stephane Lambert]

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.

[Danno]

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.

[ericlfg]

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...