Article - CS149450
Loading data in staging tables using "sqlldr" command from "SQL3" folder (multi bite) returns "Physical record in data file (WTPart.csv) is longer than the maximum(1048576)" in Windchill Bulk Migrator 2.2
Modified: 28-Sep-2022
Applies To
- Windchill Bulk Migrator 2.2 to 12.0
Description
- Loading data in staging tables using sqlldr command from SQL3 folder path (multi byte) returns error:
-
value used for ROWS parameter changed from 64 to 10SQL*Loader-510: Physical record in data file (WTPart.csv) is longer than the maximum(1048576)
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Table WTPART:
SQL*Loader-510: Physical record in data file (/opt/oracle/control/CONTENTMETADATA/CONTENTMETADATA.csv) is longer than the maximum(1048576)
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
-
- Executing "wbmlrd.sh -c" command to populate data from normalized to de-normalized table returns "Physical record in data file (WTPart.csv) is longer than the maximum(1048576)"
This is a printer-friendly version of Article 149450 and may be out of date. For the latest version click CS149450