kduchacek

how to use dbpatch

Discussion created by kduchacek on May 20, 2014

Hi,

I am trying to repair the CSP report labels by running the command below, but unfortunately it didn’t have any effect. (the output of the command is attached)

C:\clarity1320\bin>dbpatch -install -file c:\clarity1320\database\content\csp\other\CSP_RPT_LABELS_UPD_EN.xml -apply >> output.txt

I tried to run some command manually and it worked fine.

Is the way how to run the command?

If so Is there any way to figure out why it doesn’t work with dbpatch?

 

Output:

==========================================

DBTools Log - Tue May 20 10:31:51 PDT 2014

==========================================

 

Command: install database schema file

To URL: jdbc:clarity:sqlserver://localhost:1433;DatabaseName=C1320;InsensitiveResultSetBufferSize=0;ProgramName=Clarity

As user: C1320

For vendor: mssql

Option: preview mode is enabled

 

Process: CSP_RPT_LABELS_UPD_EN.xml

 

SQL Text:

 

  BEGIN

    -- 1st Request

                exec CSP_RPT_LABELS_UPD_SP '%ofProjectsKey','% of Projects',1,'en';

                exec CSP_RPT_LABELS_UPD_SP '%VarianceKey','% Variance',1,'en';

                exec CSP_RPT_LABELS_UPD_SP '6MonthPeriodKey','6 Month Period',1,'en';

……

 

  END;   

Total time: 0H:0M:2S

Attachments

Outcomes