0
0
Select * from MODELREPO.PO_FOLDER where PSF_DISCRIMINATOR='MPROOTFOLDERMARKER' and PSF_EXTERNID='U:ViEFdKwEEeaI4dJFXcyuVg'
1637 MPROOTFOLDERMARKER 13 U:ViEFdKwEEeaI4dJFXcyuVg 0 419451
Select * from MODELREPO.PO_MPPROJECT where PSM_OPID=348 and rownum<=200
Select * from MODELREPO.PO_FOLDER where POF_NAME='Project_Folder' and rownum<=500 "MODELREPO".PO_LOCKEDOBJECT 419457
Select * from "MODELREPO".PO_LOCKEDOBJECT where PSL_OPID=1030 419518
Select * from "MODELREPO".PO_PRINCIPAL where PSP_OPID=1108
Select * from "MODELREPO".PO_CHANGELISTobJECT WHERE PSC_rsiD=110355 AND cast(poc_oldpath as varchar(200)) ='Profiling_Project/Project_Folder/0RelationalDataObject/DUPLICATE_CUST_TABLE'
Select * from "MODELREPO".PO_COLLECTIONENTRY_5 where PSC_OPID=24074 110355
Select * from "MODELREPO".PO_MAPPING where PSM_OPID=1158
Select * from "MODELREPO".PO_EXECUTIONENVIRONMENT where PSE_RSID=419550 PSE_OPID=1504
Select * from "MODELREPO".PO_CHARACTERISTI2 where PSC_CONTAINER=419550
Select * from "MODELREPO".PO_PORT where PSP_CONTAINER=419550 PSP_OPID='41420'
Select * from "MODELREPO".PO_MAPPLETINTERFACECARDIN where PSM_CONTAINER=419550
Select * from "MODELREPO".PO_OUTLINELINK where PSO_CONTAINER=419550
Select * from "MODELREPO".PO_DATAHANDLER where PSD_CONTAINER=419550
Select * from "MODELREPO".PO_INSTANCE where PSI_CONTAINER=419550
Select * from "MODELREPO".PO_INSTANCE where POI_NAME='Mapplet_Input'
Select * from "MODELREPO".PO_DATAINTERFACE where PSD_CONTAINER=419550
Select * from "MODELREPO".PO_TYPEDELEMENT where PST_CONTAINER=419550
0
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_METADATA</RequestType>
<Restrictions>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>Adventure Works DW 2008R2 SE</Catalog>
</PropertyList>
</Properties>
</Discover>
Other Options
DISCOVER_DATASOURCES
DISCOVER_ENUMERATORS
DISCOVER_KEYWORDS
DISCOVER_LITERALS
DISCOVER_PROPERTIES
DISCOVER_SCHEMA_ROWSETS
"We can't solve problems by using the same kind of thinking we used when we created them - Albert Einstein"
0
ERROR: "[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002]
Cannot create the domain because of the following error: [DATAUPGRADE_00023] Internal error.
The upgrade handler with unique resource name" in Informatica 9.5.1
While installing Informatica 9.5.1, when using the infasetup.sh upgradedomainmetadata command
or DefineDomain command, they fail with the following error:
[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002]
Cannot create the domain because of the following error: [DATAUPGRADE_00023] Internal error.
The upgrade handler with unique resource name
['rn:publicid:com.informatica//ISPApplicationServiceUpgrade//IMF_Java//2.1.0to2.3.0']
and class ['com.informatica.isp.upgradehandlers.version910.ApplicationServiceUpgradeCallback']
either does not implement a public no-argument constructor or throws an exception when used..].
Cause:
This issue occurs if the number of open files is set to a lower value.
Check the value set for open files(descriptors) parameter on the Informatica server
using ulimit -a or limit command.
This issue is caused due to not having the minimum file descriptor set ?to 8192.
For installations prior to PowerCenter 9.x, it was sufficient
if the minimum file descriptor was set to 4096. However,
PowerCenter 9.5.1 needs a minimum setting of 8192 for both hard and soft file descriptors.
Sample ULIMIT output:
core file size (blocks, -c) 0 data seg size
(kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 262397 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 8192 (It should be 16000) pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 262397 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
Solution
To resolve this issue, set the ulimit for soft and hard file descriptors to a
minimum of 8192 or a recommended value of 16,000 before continuing the installation.
Informatica 9.5.1 recommends 16000 as the value for file descriptor per process.
2
Problem:
Code page in file:UTF-8 not compatible with repository code page: MS1252Error encountered while Parsing file
Reason:
This happens when we try to import UTF-8 Code page object to MS1252 Code Page
Solution: Have to Update Encoding and Code Page Details in the XML
Actual File:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
<POWERMART CREATION_DATE="01/27/2017 12:31:55" REPOSITORY_VERSION="184.93">
<REPOSITORY NAME="RS_etlprod" VERSION="184" CODEPAGE="UTF-8" DATABASETYPE="Oracle">
Update it Like below and Try importing the XML in Repo Manager:
<?xml version="1.0" encoding="Windows-1252"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
<POWERMART CREATION_DATE="01/27/2017 12:31:55" REPOSITORY_VERSION="184.93">
<REPOSITORY NAME="RS_etlprod" VERSION="184" CODEPAGE="MS1252" DATABASETYPE="Oracle">
0
on Source side :
Owner Name : SCOTT (Schema)
Source Table Name : Emp (table)
On Target Side :
Table Name Prefix : Scott(schema)
Target Table Name : DEPt (schema)
On Lookup :
Lookup table name needs to be changed.
Keep the OWNER name infront. ie
Example :
Lookup table name : SCOTT.LOCATIONS
Table looking priority if no owner name is provided
1) Under own schema
2) Public synonym.
0
SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';SELECT * FROM mysql.general_log
Take a look at the table mysql.general_log
