Data Extraction
| WHEN | PROBLEM | POSSIBLE CAUSE | CORRECTIVE ACTION |
|---|---|---|---|
| Extracting data | Extraction for Authorizations Insight for SAP is unsuccessful and arithmetic overflow exception is recorded |
The ID column of the following tables may have exceeded the maximum value assigned: Approva_SCI_SAP_DirectoryOfRepos itoryObjects Approva_AI_SAP_UsermasterAuthorizationsObjects Approva_AI_SAP_R3DDDataelementtexts Approva_AI_SAP_UsermasterSingleprofiles AuthorizationAttributes ApplicationRoleAuthorizations Authorizations |
Configure stored procedure SAPAI_ArithmeticOverflow_MaintenancePlan in your Database Maintenance Plan for SQL Server and execute on a monthly basis. |
| Extraction for SCI is unsuccessful and arithmetic overflow exception is recorded |
The ID column of tables may have exceeded the maximum value assigned. For details on the table names, refer to the document IRC System Configuration Insight for SAP Advanced Configuration Settings. |
Configure stored procedure SAPSCI_ArithmeticOverflow_MaintenancePlan in your Database Maintenance Plan for SQL Server and execute on a monthly basis | |
| Scheduled Extraction/ Mapping won’t run. | Credentials are incorrect or have insufficient privileges in the ERP system. | Open the scheduled job and check the account. Reset the password. | |
| Online data extraction using Process Insights | Extraction stops at the Upload data stage of online Process Insight extraction, resulting in failure of the task. | The creator of the IRC database is not the current owner of the database. | Launch the Job Activity Monitor from the SQL Server Agent on the IRC database to check whether an error message is displayed in the. If the error message is displayed, click http://support.microsoft.com/kb/918040 to refer to KB article for corrective action. |
| Online data extraction using Process Insights | Extraction fails at upload with the error 'Error while creating scheduled job for upload' | Database server name is Localhost | Provide the actual server name. |
| PI Extraction | PI Extraction hangs at the Upload steps | Trust relationship for the SSL/TLS secure channel cannot be established. | If IRC is SSL enabled, import SSL certificate from the Application Server to the Database Server into the Trusted Root Certification Authorities folder. |
| Online data extraction using the Lawson Insights | Extraction fails | Distributed Single Sign-On (DSSO) is not installed and configured on the machine. | Install and configure DSSO before scheduling an extraction. |
| Online data extraction using Lawson Insights | Extraction fails with the error ‘Your OS Account has not been configured for Authentication’. | The user name used for creating the identity for the new OS service while configuring DSSO and the Adapter Service context user are not the same. | Ensure that the user name used for creating identity for new OS service while configuring DSSO and the Adapter Service context user are the same. |
| Data Extraction fails | The Task Manager page displays the error – ‘Could not find file '\\Serv02287\UploadedFiles\IONAI_135_722.csv'.’ | Add the directory, for example, ‘C:\Program Files\Microsoft SQL Server\100\Tools\Binn’ in the environment path variable that contains the bcp utility for the sql server Restart Infor IRC Adapter Service. | |
| SAP IMG offline data upload and online data extraction | Extraction fails with Root Element Missing error | Restart IRC services and reschedule online extraction or offline file upload. | |
| Offline Extraction | Data not displayed after performing offline extraction. This occurs if the offline connection is created from the Import Connection page. | Read-only access permission provided to the folder containing extracted data. | Remove the read-only access from the offline folder that contains the offline extracted data |
Locate the parameters being used for the object extraction of Lawson PI and Inventory Insight in date_TM_CM.logs at install path\Adapters\TMonitor\Logs folder.
For example to locate the parameters for APINVOICE object –
4/19/2013 §§ 9:46:54 AM §§ Information §§ CDMLawsonHelper - ExtractChunk() : Extracting data for APPROVA.BIZRIGHTS_XI.LAWSONS3.APINVOICE
4/19/2013 §§ 9:47:04 AM §§ Information §§ CallLawsonJavaPlugin() started. Input XML:
<ExtractionDetails><PROD>APPS100</PROD><NEXT>TRUE</NEXT><DELIM>$$$$!@**</
DELIM><BEGIN></BEGIN><OUT>CSV</OUT><FILE>APINVOICE</
FILE><FIELD>APPROVED_FLAG;APPRV_OPERATOR;BANK_INST_CODE;
CANCEL_DATE;CANCEL_SEQ;CASH_CODE;COMPANY;CREATE_DATE;DESCRIPTION;
DISC_DATE;DISCOUNT_RT;DISTRIB_DATE;DUE_DATE;FLOAT_DAYS;HANDLING_CODE;
INV_CURRENCY;INV_STATUS;INVC_REF_TYPE;</FIELD><MAX>10000</MAX><WHERE>
((CREATE_DATE^>=19990101&CREATE_DATE^<=20130419))|
((LAST_UPDT_DATE^>=19990101&LAST_UPDT_DATE^<=20130419))</
WHERE><INDEX>APISET1</INDEX></ExtractionDetails>
