on 04-07-2010 6:49 PM
Hi,
Have just installed DS 3.2 SP2 on windows 2008 R2.
We have deployed the DS software on a server different from the server holding the SQL server repositories.
DS Designer is installed on desktops.
We have created a cleansing package repository and are now trying to attach the repository (using "manage connection") in the DS designer.
But when attaching the Designer crashes.
Not sure if it has any relevance, but we installed the SQL server native client on the client desktops to ensure proper connectivity to SQL server DBs and repositories.
More relevant could be the fact that we had to install the cleansing package on a client to seed the cleasning package repository. When running the repository manager on the server we are not able to create the repository, even if we have installed the 64 bit SQL server cnative client software. The repository manager simply replies that the repository we have specifed does not exist (Which is right), and then terminates (instead of creating the repository).
But as mentioned the repository was eventually created by using repository manager on a desktop client.
Regards
Thomas
Hi Sarthak
Yes, we changed the password.
I have forwarded the log files in separate e-mail.
/Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
We solved the crash problem. It was caused by the fact that there were special characters in the repository DB password.
But we still face the problem that the repository manager does not install the cleansing packages.
Regardless of there being a dictionary in the repository or not, the rep manager just checks whether there is a repository and finds that: "yes there is a repository" and then nothing happens.
Any ideas?
/Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The designer also crashes when launched from the server.
It seems to me that the same protocol should be used for connecting to the local repository (which works fine) as connecting to the cleansing repository. (Why is there a difference in behavior?).
We will try to create a database on the same server as designer is launched (Using MSSQL express).
/Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thomas,
I saw this somewhere near the top of this thread : We installed the 64 bit version. (for the MS SQL client)".
Just want to point out that on Windows Data Services is a 32-bit executable (for now) and will require the 32-bit libraries to connect to databases and applications from the respective vendors. So for MS SQL 2008 we need the 32-bit SQL Server 2008 Native Client (ODBC).
But I'm not sure this is really he issue. I assume your local repo is also on MS SQL Sever 2008 and since you seem to be able to login to Data Services, the connectivity and drivers seem to be fine. It's probably easiest to get support involved here, this makes it easier to follow-up (will send you a mail with instructions).
Thanks,
Ben
Edited by: Ben Hofmans on Apr 19, 2010 1:27 PM- spell check
Again with line feed.
Example Danish Cleansing Package
Connection Information:
Database type: SQL Server 2008
Database server name: dksapbobj02\dksapbobj02
Database name: DS_REPO_UDC
User name: sa
Password: ***
DCRI Library Version: "1.08".
Verifying the cleansing package repository connection.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "VALID_CONNECTION,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" ""
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 10.0.1600.22
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q ""
Return code: 0
Successfully verified the cleansing package repository connection.
Extracting "PERSON_FIRM_DA_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o
"C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip"
PERSON_FIRM_DA_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
Checking whether the cleansing package repository exists.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "CHECK_FOR_REPOSITORY,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id =
object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'EXIST'" -o "C:\Program Files\Business
Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Output:
-
EXIST
(1 rows affected)
Return code: 0
The cleansing package repository exists.
Acquiring schema version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_SCHEMA_VERSION,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id =
object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select TOP 1 'SCHEMA_VERSION=' +
cast(SCHEMAVERSION as varchar(10)) AS SQL_SCHEMA_VERSION from DC_DICTIONARY ORDER BY SCHEMAVERSION" -o
"C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Output:
SQL_SCHEMA_VERSION
-
SCHEMA_VERSION=3
(1 rows affected)
Return code: 0
The schema version found in the target cleansing package repository is "3".
Extracting "PERSON_FIRM_DA_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o
"C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip"
PERSON_FIRM_DA_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
"PERSON AND FIRM (DANISH)" Cleansing Package ***
The schema version for the "PERSON AND FIRM (DANISH)" source Cleansing Package is "3".
The schema versions found in the target cleansing package repository and the "PERSON AND FIRM (DANISH)" source Cleansing
Package are compatible.
Acquiring the "PERSON AND FIRM (DANISH)" dictionary version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_DICTIONARY_VERSION,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt" PERSON_FIRM_DA
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id =
object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'DICTIONARY_VERSION=' +
cast(DICTIONARYVERSION as varchar(10)) AS SQL_DICT_VERSION from DC_DICTIONARY WHERE NAME = 'PERSON_FIRM_DA'" -o
"C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt"
Output:
SQL_DICT_VERSION
-
DICTIONARY_VERSION=2
(1 rows affected)
Return code: 0
The dictionary version found in the target cleansing package repository is "2".
The dictionary version found in the "PERSON AND FIRM (DANISH)" source Cleansing Package is "2".
The "PERSON AND FIRM (DANISH)" dictionary already exists in the specified cleansing package repository.
Example English Cleansing Package
Connection Information:
Database type: SQL Server 2008
Database server name: dksapbobj02\dksapbobj02
Database name: DS_REPO_UDC
User name: sa
Password: ***
DCRI Library Version: "1.08".
Verifying the cleansing package repository connection.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "VALID_CONNECTION,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" ""
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 10.0.1600.22
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q ""
Return code: 0
Successfully verified the cleansing package repository connection.
Extracting "PERSON_FIRM_EN_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o
"C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip"
PERSON_FIRM_EN_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
Checking whether the cleansing package repository exists.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "CHECK_FOR_REPOSITORY,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id =
object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'EXIST'" -o "C:\Program Files\Business
Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Output:
-
EXIST
(1 rows affected)
Return code: 0
The cleansing package repository exists.
Acquiring schema version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_SCHEMA_VERSION,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id =
object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select TOP 1 'SCHEMA_VERSION=' +
cast(SCHEMAVERSION as varchar(10)) AS SQL_SCHEMA_VERSION from DC_DICTIONARY ORDER BY SCHEMAVERSION" -o
"C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Output:
SQL_SCHEMA_VERSION
-
SCHEMA_VERSION=3
(1 rows affected)
Return code: 0
The schema version found in the target cleansing package repository is "3".
Extracting "PERSON_FIRM_EN_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o
"C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip"
PERSON_FIRM_EN_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
"PERSON AND FIRM (ENGLISH)" Cleansing Package ***
The schema version for the "PERSON AND FIRM (ENGLISH)" source Cleansing Package is "3".
The schema versions found in the target cleansing package repository and the "PERSON AND FIRM (ENGLISH)" source Cleansing
Package are compatible.
Acquiring the "PERSON AND FIRM (ENGLISH)" dictionary version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_DICTIONARY_VERSION,2008" "dksapbobj02\dksapbobj02"
"DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt" PERSON_FIRM_EN
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id =
object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'DICTIONARY_VERSION=' +
cast(DICTIONARYVERSION as varchar(10)) AS SQL_DICT_VERSION from DC_DICTIONARY WHERE NAME = 'PERSON_FIRM_EN'" -o
"C:\Program Files\Business Objects\BusinessObjects Data
Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt"
Output:
SQL_DICT_VERSION
-
(0 rows affected)
Return code: 0
The "PERSON AND FIRM (ENGLISH)" Cleansing Package dictionary is not in the cleansing package repository.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Looks like you have the Danish CP installed OK.
Were you able to try to connect from the server side Designer?
I am thinking this might be an issue related to the SQL client setup. You had mentioned you had the native client installed - does that imply the full client package? If not, would it be possible for you to install it the full client on one of the machines?
Thanks,
Sarthak
Hi Sarthak
Please find below the info provided in the repomanager. I don't think we have issues with space.
It seems quite OK.
Danish Cleansing Package:
Connection Information:
Database type: SQL Server 2008
Database server name: dksapbobj02\dksapbobj02
Database name: DS_REPO_UDC
User name: sa
Password: ***
DCRI Library Version: "1.08".
Verifying the cleansing package repository connection.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "VALID_CONNECTION,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" ""
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 10.0.1600.22
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q ""
Return code: 0
Successfully verified the cleansing package repository connection.
Extracting "PERSON_FIRM_DA_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip" PERSON_FIRM_DA_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
Checking whether the cleansing package repository exists.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "CHECK_FOR_REPOSITORY,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id = object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'EXIST'" -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Output:
-
EXIST
(1 rows affected)
Return code: 0
The cleansing package repository exists.
Acquiring schema version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_SCHEMA_VERSION,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id = object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select TOP 1 'SCHEMA_VERSION=' + cast(SCHEMAVERSION as varchar(10)) AS SQL_SCHEMA_VERSION from DC_DICTIONARY ORDER BY SCHEMAVERSION" -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Output:
SQL_SCHEMA_VERSION
-
SCHEMA_VERSION=3
(1 rows affected)
Return code: 0
The schema version found in the target cleansing package repository is "3".
Extracting "PERSON_FIRM_DA_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_DA.zip" PERSON_FIRM_DA_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
"PERSON AND FIRM (DANISH)" Cleansing Package ***
The schema version for the "PERSON AND FIRM (DANISH)" source Cleansing Package is "3".
The schema versions found in the target cleansing package repository and the "PERSON AND FIRM (DANISH)" source Cleansing Package are compatible.
Acquiring the "PERSON AND FIRM (DANISH)" dictionary version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_DICTIONARY_VERSION,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt" PERSON_FIRM_DA
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id = object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'DICTIONARY_VERSION=' + cast(DICTIONARYVERSION as varchar(10)) AS SQL_DICT_VERSION from DC_DICTIONARY WHERE NAME = 'PERSON_FIRM_DA'" -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt"
Output:
SQL_DICT_VERSION
-
DICTIONARY_VERSION=2
(1 rows affected)
Return code: 0
The dictionary version found in the target cleansing package repository is "2".
The dictionary version found in the "PERSON AND FIRM (DANISH)" source Cleansing Package is "2".
The "PERSON AND FIRM (DANISH)" dictionary already exists in the specified cleansing package repository.
English Cleansing Package:
Connection Information:
Database type: SQL Server 2008
Database server name: dksapbobj02\dksapbobj02
Database name: DS_REPO_UDC
User name: sa
Password: ***
DCRI Library Version: "1.08".
Verifying the cleansing package repository connection.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "VALID_CONNECTION,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" ""
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 10.0.1600.22
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q ""
Return code: 0
Successfully verified the cleansing package repository connection.
Extracting "PERSON_FIRM_EN_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip" PERSON_FIRM_EN_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
Checking whether the cleansing package repository exists.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "CHECK_FOR_REPOSITORY,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id = object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'EXIST'" -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcrisqlserver_repo_exist.txt"
Output:
-
EXIST
(1 rows affected)
Return code: 0
The cleansing package repository exists.
Acquiring schema version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_SCHEMA_VERSION,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id = object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select TOP 1 'SCHEMA_VERSION=' + cast(SCHEMAVERSION as varchar(10)) AS SQL_SCHEMA_VERSION from DC_DICTIONARY ORDER BY SCHEMAVERSION" -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_schema_version.txt"
Output:
SQL_SCHEMA_VERSION
-
SCHEMA_VERSION=3
(1 rows affected)
Return code: 0
The schema version found in the target cleansing package repository is "3".
Extracting "PERSON_FIRM_EN_VERSION.txt" from "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip".
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\unzip" -j -qq -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\PERSON_FIRM_EN.zip" PERSON_FIRM_EN_VERSION.txt -d "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP"
Command Output:
Return code: 0
"PERSON AND FIRM (ENGLISH)" Cleansing Package ***
The schema version for the "PERSON AND FIRM (ENGLISH)" source Cleansing Package is "3".
The schema versions found in the target cleansing package repository and the "PERSON AND FIRM (ENGLISH)" source Cleansing Package are compatible.
Acquiring the "PERSON AND FIRM (ENGLISH)" dictionary version from the cleansing package repository.
Execute Command: "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\dcrisqlserverutil.bat" "GET_DICTIONARY_VERSION,2008" "dksapbobj02\dksapbobj02" "DS_REPO_UDC" FALSE "sa" "$PWD$" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP" "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt" PERSON_FIRM_EN
Command Output:
C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP>echo off
sqlcmd -S "dksapbobj02\dksapbobj02" -d "DS_REPO_UDC" -U "sa" -P *** -Q "if exists (select * from dbo.sysobjects where id = object_id(N'[DC_DICTIONARY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'DICTIONARY_VERSION=' + cast(DICTIONARYVERSION as varchar(10)) AS SQL_DICT_VERSION from DC_DICTIONARY WHERE NAME = 'PERSON_FIRM_EN'" -o "C:\Program Files\Business Objects\BusinessObjects Data Services\DataQuality\datacleanse\DC_TEMP\dcri_dictionary_version.txt"
Output:
SQL_DICT_VERSION
-
(0 rows affected)
Return code: 0
The "PERSON AND FIRM (ENGLISH)" Cleansing Package dictionary is not in the cleansing package repository.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Will get the detailed info later today.
But I remember that we were able to install one cleansing package into the repository. And when trying to select more cleansing packages for addition to the repository, nothing happened.
/Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Each CP gets installed exactly the same way and installing one is independent of the other. Could it be possible that you ran into some space limitations on your DB and/or your local machine when installing the CP?
When you say "nothing happened" with the 2nd CP you tried to install, did repository manager show any messages in the log window as to what was being executed?
This might end up being something you would have to take to Customer Support since it seems to be specific to your environment/setup.
Sarthak
Hi,
We are using SQL server 2008. on the job server machine and on clients we have installed:
"Microsoft SQL Server 2008 Native Client"
and
"Microsoft SQL Server 2008 Command Line Utilities"
Which can be found on:
We installed the 64 bit version.
And yes, Designer crashes after pressing OK.
Best regards
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Could you try the following 2 things:
1. Run RepoMan on the desktop and select Cleansing Packages, point to your server and click GetVersion (with Show details enabled). I was interested in seeing if it detects any of the CP's that you managed to install or not.
2. Can you log into the designer from the Server box and try going to Manage Connections from there? See if that also crashes or not.
Hi Thomas,
What version of SQL Server are you using for the UDC repository and what is the SQL client version from where you are trying to connect?
Also, when you say it crashes, do you mean you enter the connection info in "Manage Connections", click OK and then designer closes down?
Thanks,
Sarthak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.