Difference between revisions of "ARS1129E"
m (Fixed link to arsload.) |
(Added a note to remove extra space characters or tabs around the date fields for ARS1129E.) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 20: | Line 20: | ||
== What happened? == | == What happened? == | ||
The date format that was inside the file didn't match the date format that was expected by CMOD, in the Application configuration. | The date format that was inside the file didn't match the date format that was expected by CMOD, in the Application configuration. | ||
In the example above, CMOD was expecting dashes between the year and month and day of the month. In order for OnDemand to be able to properly parse the date, it must match the format defined in the Application. | |||
== Troubleshooting == | == Troubleshooting == | ||
Using the Row number in the error message, check the Generic Index file to determine which field the error relates to. Then, using the IBM CMOD Administrator Client to update the date format to match the format of the data itself. In the case of this example, remove the dash ("-") characters from the date format string, and attempt the load again. | Using the Row number in the error message, check the Generic Index file to determine which field the error relates to. Then, using the IBM CMOD Administrator Client to update the date format to match the format of the data itself. In the case of this example, remove the dash ("-") characters from the date format string, and attempt the load again. | ||
Also, check the Application definition, under Load Parameters - select the date field that is causing problems, and check the date field parameters -- ensure there are no spaces or tab characters ''before'' or ''after'' the date field specification (like %m/%d/%Y). As a reminder, the 'Character Removal' fields only remove characters from the INPUT fields, not the date field specification itself! | |||
== Articles Related to this message == | == Articles Related to this message == | ||
Latest revision as of 17:27, 5 March 2025
What was the error?
Message Number: 1129
Message Severity: Error (Corrective action is required to continue)
Message Name: ARS1129E
Message Text: Row X: The string "20190125" could not be converted to a date from the format of %Y-%m-%d
Example
ARS1129E Row 1: The string "20190125" could not be converted to a date from the format of %Y-%m-%d
Related Errors
What were you doing?
You were trying to load data into CMOD using arsload, possibly for the first time since the Application Group or Application was configured.
What happened?
The date format that was inside the file didn't match the date format that was expected by CMOD, in the Application configuration.
In the example above, CMOD was expecting dashes between the year and month and day of the month. In order for OnDemand to be able to properly parse the date, it must match the format defined in the Application.
Troubleshooting
Using the Row number in the error message, check the Generic Index file to determine which field the error relates to. Then, using the IBM CMOD Administrator Client to update the date format to match the format of the data itself. In the case of this example, remove the dash ("-") characters from the date format string, and attempt the load again.
Also, check the Application definition, under Load Parameters - select the date field that is causing problems, and check the date field parameters -- ensure there are no spaces or tab characters before or after the date field specification (like %m/%d/%Y). As a reminder, the 'Character Removal' fields only remove characters from the INPUT fields, not the date field specification itself!