Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

infacmd.sh createconnection fails when connection option has space or equal "=" sign
Problem Description
When a connection is created from command line, multiple options need to provide in -o option:

infacmd.sh createconnection
[ICMD_10023] Missing required command option: [<-DomainName|-dn>]
Usage:
<-DomainName|-dn> domain_name
<-UserName|-un> user_name
<-Password|-pd> password
[<-SecurityDomain|-sdn> security_domain]
[<-ResilienceTimeout|-re> timeout_period_in_seconds]
<-ConnectionName|-cn> connection_name
<-ConnectionId|-cid> connection_id
<-ConnectionType|-ct> connection_type
[<-ConnectionUserName|-cun> connection_user_name]
[<-ConnectionPassword|-cpd> connection_password]
<-Options|-o> options, separated by space in the form of name=value. Use single quote to escape any equal sign or space in the value.
Defines a connection and the connection options.

Here some option may have = (equal sign) or space
E,g,
ODBCProvider : Microsoft SQL Server
MetadataAccessConnectString : jdbc:informatica:sqlserver://insapec6u\Adapter:1433;databaseName=adapter_semantic

Both the options have = OR space

If we give the ' (single quote) around these values and try to create connection from Linux System then it throws error:

$ infacmd.sh createconnection -dn Domain_informatica -un Administrator -pd Administrator -cn Mapping_SQLSERVER -cid Mapping_SQLSERVER -ct ODBC -cun semantic_123 -cpd sem345_123 -o DataAccessConnectString=insapec6u_Adapter_semant CodePage=UTF-8 EnableConnectionPool=true EnableQuotes=true QuoteChar=3 ODBCProvider='Microsoft SQL Server'

[ICMD_10033] Command [createconnection] failed with error [[ISPCMD_10406] Invalid character at [146] in [DataAccessConnectString=insapec6u_Adapter_semant CodePage=UTF-8 EnableConnectionPool=true EnableQuotes=true QuoteChar=3 ODBCProvider=Microsoft SQL Server].].​

Note that this error is not seen on Windows installations.
Cause
​This has been reported as a bug (OCON-1625) to be addressed in a future release. 
Solution
Workaround:

Double quotes (") must be used before and after set of all options:
 

Example

 
$ infacmd.sh createconnection -dn Domain_informatica -un Administrator -pd Administrator -cn Mapping_SQLSERVER -cid Mapping_SQLSERVER -ct ODBC -cun semantic_123 -cpd sem345_123 -o "DataAccessConnectString=insapec6u_Adapter_semant CodePage=UTF-8 EnableConnectionPool=true EnableQuotes=true QuoteChar=3 ODBCProvider='Microsoft SQL Server'"

Command ran successfully.
More Information
Applies To
Product: PowerCenter
Problem Type: Configuration
User Type: Administrator; Developer
Project Phase: Configure; Implement; Onboard
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/13/2019 4:15 PMID:318712
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)