Project and Portfolio Management Practitioners Forum
cancel

Error in kDeploy.sh -tidy

Highlighted
Sascha_1
Super Contributor.

Error in kDeploy.sh -tidy

Hello,

 

after upgrading from PPM 8.03 to PPM 9.13, i want to check the orphan files from previous deployments. Therefore i run the following command with related output:

 

$ sh kDeploy.sh -l
JAVA_HOME = D:/Java/jdk1.6.0_21
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_21-b07)
Java HotSpot(TM) Client VM (build 17.0-b17, mixed mode, sharing)

Please enter the DB password for ppm_user:

Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.

Deployment          Version Deployed                                                            Description
-------------------------------------------------------------------------------------------------------------------------------
SP3                          913  2012-02-08 11:45:29                                           Service Pack 3 9,1,3,478
SP3                          803  2011-07-11 09:39:01                                           Service Pack 3 8,0,3,1208
BestPractices        803  2011-05-20 16:26:01                                           Mercury ITG Best Practices
SP3                          803  2011-05-20 10:25:11                                           Service Pack 3 8,0,3,1189
SP2                          802  2010-11-04 13:09:13                                           Service Pack 2 8,0,2,313
LangPack               800  2010-11-03 15:08:08                                            Lang Pack/de Additional Languag build.111
BestPractices        750  2010-08-24 15:24:28                                            Mercury ITG Best Practices
SP6                          750  2010-08-24 15:19:48                                           Service Pack 6 7,5,0,1834

 

After this result, i run the following command. But everytime, the command failed:

 

$ sh kDeploy.sh -tidy
JAVA_HOME = D:/Java/jdk1.6.0_21
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_21-b07)
Java HotSpot(TM) Client VM (build 17.0-b17, mixed mode, sharing)

Please enter the DB password for ppm_user:

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
                       DEPLOYMENT CLEANUP
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Looking for installed deployments/patches backup/deployment files
to remove.  This will not affect the behavior of your server.  The
files that are cleaned up are either:

  1) STAGING files that are only needed for the duration of the
     deployment (these are found in the deploy/ directory and are
     created whenever kDeploy.sh is run)
  2) BACKUP files.  Whenever a deployment is installed any file that
     is overwritten is first backed up to file.<ID>.  Over time this
     can amount to a lot of extra files that are not needed.

Would you like to continue? (Y/N/M) :
  [Y] to continue
  [N] to cancel
  [M] to list the files that would have been deleted.
      (files will NOT be deleted)
M
java.sql.SQLSyntaxErrorException: ORA-00904: "PATCH_NUMBER": invalid identifier

 

Does anyone know this error?

Best Regards,

Sascha

9 REPLIES
dirkf
Acclaimed Contributor.

Re: Error in kDeploy.sh -tidy

Yo Sascha,

 

hope all is well with you.

 

I tested this and get the same, with M selected, so as not to delete the files but just a list of them.

 

Log a case, and paste the stack. At least when submitting the deploy with M I get a big fat stack...Reference me has already having it rreproduced and we'll see how to proceed ;-)

(well, you might want someone else to look at it maybe, hehe)

 

Best regards,

Dirk

 

- Kudos always welcome -

 

dirkf
Acclaimed Contributor.

Re: Error in kDeploy.sh -tidy

Hi Sascha,

 

ok, the error message is disturbing but cosmetic.

 

If you wait, the 'M'-parameter will list the files. If you run 'Y' it will throw the same error but clean out the files and complete successfully.

 

Log a P3 and I'll take it.

 

Best regards,

Dirk

 

- Kudos always welcome -

Sascha_1
Super Contributor.

Re: Error in kDeploy.sh -tidy

Hi Dirk,

case was openend with prio 3.

Regards,
Sascha
dirkf
Acclaimed Contributor.

Re: Error in kDeploy.sh -tidy

Hi Sascha,

 

 I did notice something on the fly:

 

Since hotfixes are deployed using kDeploy, there is a new table in 9.13 by the name of KNTA_PATCHES.

 

Description of the table is the following:

This table stores information about deployment of patches on the PPM Server

(hotfixes), including the full list of files deployed as part of the hotfixes. It is

populated when hotfixes are deployed using the kDeploy script.

 

It seems that the script is trying to locate the column PATCH_NUMBER in this table.

The column isn’t present in this table however. The columns are:

 

Column Name

DEPLOYMENT_ID

PATCH_DESC

INCIDENT_NUMBER

DEFECT_NUMBER

FILE_PATH

FILE_FROM

DEPLOY_DATE

MACHINE_NAME

PPM_VERSION

FILE_SIZE

 

The column PATCH_NUMBER is found in older and newer minors of 9.1 (at least) in the table KINS_UPGRADE_LOGS.

 

I'm not 100% sure, but I think that might be the cause of the issue. RnD are already on top of it though based on your ticket, so I'm sure we'll get an update soon.

 

Best regards

Dirk

AlexSavencu
Acclaimed Contributor.

Re: Error in kDeploy.sh -tidy

Hi, Dirk,

Is there a public defect for this?

Cheers
Alex

--remember to kudos people who helped solve your problem
dirkf
Acclaimed Contributor.

Re: Error in kDeploy.sh -tidy

Hi Alex,

 

the issue is still under investigation, so no CR so far.

I'M sure that either Sascha or myself will post it as soon as it becomes available.

 

Best regards,

Dirk

Sascha_1
Super Contributor.

Re: Error in kDeploy.sh -tidy

Hi guys,

Maky is still investigating on this issue. It seems one of sql statements causes the error trying to catch the patch_number.

select * from KNTA_PATCHES
Error at Command Line:19 Column:14
Error report:
SQL Error: ORA-00942: table or view does not exist

SELECT t.table_name FROM USER_TABLES t WHERE t.table_name LIKE '%PATCH%'

TABLE_NAME
------------------------------
KINS_PATCHES
KDLV_PATCH_REPORT_TMP

select * from KINS_PATCHES

RESULT: EMPTY
dirkf
Acclaimed Contributor.

Re: Error in kDeploy.sh -tidy

Hi Sascha,

 

hmm, you would see me sit here bewildered. I already wrote that on the 7th - see my post above. The patch_numer is not in the table.

I'll talk to Maky when she comes in.

 

Best regards,

Dirk

Sascha_1
Super Contributor.

Re: Error in kDeploy.sh -tidy

Hi Dirk,

I saw your post. I will see what Maky wants to do.

Best Regards,
Sascha