CA Client Automation

Hi!! people

Server:

DM : SO 2012 , Standalone SQL2014

ITCM Version: 12.9 in update r14.1

Media: DVD07135318M

Problem: install MDB

print

ERROR

Tests 

Run media local and  extract ISO files, not resolved.

View  logs 

SQL logs 

%temp%\ install_mdb.log

HELP PLIS.

OPEN CASE 00816996  not resolved

Look in the directory C:\Program Files (x86)\CA\SC\Windows\logs to see the mdb install log

Richard Lechner

Principal Engineering Services Architect

CA Technologies

Mobile: +1 703 655 7161 | Richard.Lechner@ca.com

<mailto:Richard.Lechner@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>

install_mdb.log:

Please run the following two statements in SQL, and share the results:

select * from syscolumns where id=object_id('rpglobal') and name='subname'
select * from rpglobal

Results from my environment:

That first result has many columns that are cut off in the screenshot, but we are just looking to see if any result for "subname" is returned.

The second result is the contents of my rpglobal table, in which we can see the second column is titled "subname".

-Brian

Find  logs 

08-15,15:45:01 WARN - Insertion of seed data failed
08-15,15:45:01 WARN - com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'XPKca_language'. Cannot insert duplicate key in object 'dbo.ca_language'. The duplicate key value is (IW ).

INSERT INTO ca_language ( lang_code, lang_name, creation_user, creation_date, last_update_user, last_update_date, language_uuid, source_type_id, tenant ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? )

AND

08-15,15:45:06 INFO - MDBTools_0306I - SQL text:
08-15,15:45:06 INFO - IF EXISTS (select * from syscolumns where id=object_id('rpglobal') and name='subname')
08-15,15:45:06 INFO - BEGIN
08-15,15:45:06 INFO - ALTER TABLE [rpglobal] ALTER COLUMN [subname] nvarchar ( 127 ) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
08-15,15:45:06 INFO - END
Update sql failed:
IF EXISTS (select * from syscolumns where id=object_id('rpglobal') and name='subname')
BEGIN
ALTER TABLE [rpglobal] ALTER COLUMN [subname] nvarchar ( 127 ) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
END
08-15,15:45:06 DEBUG - The object 'XPKrpglobal' is dependent on column 'subname'.
08-15,15:45:06 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
08-15,15:45:06 INFO - MDBTools_0305E - Error processing table 'rpglobal.xml'; details follow:
08-15,15:45:06 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The object 'XPKrpglobal' is dependent on column 'subname'.
com.microsoft.sqlserver.jdbc.SQLServerException: The object 'XPKrpglobal' is dependent on column 'subname'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:799)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:696)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:669)
at com.ca.mdbtools.DriverApp.updateDB(DriverApp.java:2697)
at com.ca.mdbtools.DriverApp.apply(DriverApp.java:2256)
at com.ca.mdbtools.DriverApp.installSchemaDriver(DriverApp.java:1085)
at com.ca.mdbtools.Utilities.run(Utilities.java:1678)
at com.ca.mdbtools.Utilities.main(Utilities.java:1042)
08-15,15:45:06 ERROR - MDBTools_0307E - SQL text:
08-15,15:45:06 ERROR - IF EXISTS (select * from syscolumns where id=object_id('rpglobal') and name='subname')
08-15,15:45:06 ERROR - BEGIN
08-15,15:45:06 ERROR - ALTER TABLE [rpglobal] ALTER COLUMN [subname] nvarchar ( 127 ) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
08-15,15:45:06 ERROR - END
08-15,15:45:06 ERROR - MDBTools_0309E - DBDriver failed to install!
08-15,15:45:06 INFO - MDBTools_0104I - Total time: 0H:0M:9S.
08-15,15:45:07 MDBTools install error=3
08-15,15:45:07 Setupmdb exit return code=3

I am execute manuel  command.viewer log 

IF EXISTS (select * from syscolumns where id=object_id('rpglobal') and name='subname')
BEGIN
ALTER TABLE [rpglobal] ALTER COLUMN [subname] nvarchar ( 127 ) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
END

error 

Msg 5074, Level 16, State 1, Line 7
The object 'XPKrpglobal' is dependent on column 'subname'.
Msg 4922, Level 16, State 9, Line 7
ALTER TABLE ALTER COLUMN subname failed because one or more objects access this column.

print

Brian  thks for  help.

print

Execute manual script: make_MDB_104_compatible.bat in %temp%\ITRM\database\mdb_install

create new log and error

08-16,12:02:48 INFO - WHERE (stats.productid = productidview.productid)
Update sql failed:CREATE VIEW "processlistview" AS
SELECT DISTINCT "stats"."processid", "stats"."processname"
FROM "stats", "productidview"
WHERE (stats.productid = productidview.productid)

08-16,12:02:48 DEBUG - Invalid object name 'productidview'.
08-16,12:02:48 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
08-16,12:02:48 INFO - processlistview.xml is added to the retry queue.
08-16,12:02:48 INFO - MDBTools_0303I - Processing view: productidview.xml timestamp: 1970-01-01T00:00:00+0000
08-16,12:02:48 INFO - MDBTools_0306I - SQL text:
08-16,12:02:48 INFO - CREATE VIEW "productidview" AS
08-16,12:02:48 INFO - SELECT "productids"."productid"
08-16,12:02:48 INFO - FROM "productids", "productkeyview"
08-16,12:02:48 INFO - WHERE productids.productkey = productkeyview.product_key
Update sql failed:CREATE VIEW "productidview" AS
SELECT "productids"."productid"
FROM "productids", "productkeyview"
WHERE productids.productkey = productkeyview.product_key

08-16,12:02:48 DEBUG - Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
08-16,12:02:48 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
08-16,12:02:48 INFO - MDBTools_0305E - Error processing view 'productidview.xml'; details follow:
08-16,12:02:48 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

At a command prompt run sqlcmd

Does it exist.  If not install sql management tools complete

Richard Lechner

Principal Engineering Services Architect

CA Technologies

Mobile: +1 703 655 7161 | Richard.Lechner@ca.com

<mailto:Richard.Lechner@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>

Hi, Richard

you have one command  test validade  sqlcmd 

Not specifically usually it means the command line does not exist or could not find it.  I assume you are running the command on the same machine you are doing the install on.

Richard Lechner

Principal Engineering Services Architect

CA Technologies

Mobile: +1 703 655 7161 | Richard.Lechner@ca.com

<mailto:Richard.Lechner@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>

Yes, everything local

Problem resolved.

The problem was listed below.

MDBTools_0306I - SQL text:
IF EXISTS (select * from syscolumns where id=object_id('rpglobal') and name='subname')
BEGIN
ALTER TABLE [rpglobal] ALTER COLUMN [subname] nvarchar ( 127 ) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
END
Update sql failed:

The object 'XPKrpglobal' is dependent on column 'subname'.
MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
MDBTools_0305E - Error processing table 'rpglobal.xml'; details follow:
com.microsoft.sqlserver.jdbc.SQLServerException: The object 'XPKrpglobal' is dependent on column 'subname'.

SOLUCION:

USE [mdb]
GO

/****** Object: Index [XPKrpglobal] Script Date: 16/08/2017 15:23:38 ******/
ALTER TABLE [dbo].[rpglobal] DROP CONSTRAINT [XPKrpglobal]
GO

After the installation it re-created the primary key.

Remembering: Always back up before

select * from syscolumns where id=object_id('rpglobal') and name='subname'
select * from rpglobal

After: SQL_Latin1_General_CP1_CI_AS

before: SQL_Latin1_General_CP1_CS_AS

 After he finished everything went back to normal and recreated rpglobal and changed

This error no longer exists.
Can not resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

THKS FOR ALL