Kbase P111929: Modifying SDO query at runtime fails with ICFDB on a Unix machine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/19/2005 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
Dynamics
SYMPTOM(s):
Dynamics
Modifying SDO query at runtime fails
addQueryWhere and other API calls appear to be ignored
ICFDB located on a UNIX system
Checking SDO base query string shows ~r sequences
ICFDB created by loading .df and .d's
.df and .d files dumped on Windows system
CAUSE:
.df and .d files not transferred properly to the UNIX system.
Because of this, the Windows linefeeds (CHR(13)+CHR(10) characters) are not converted properly to UNIX linefeeds (just CHR(10) character).
This results in excess CHR(13)'s in the query string (represented as ~r), which cause later string manipulations to fail.
This can happen for example if the .df and .d files were transferred via binary FTP instead of ASCII FTP.
FIX:
- Make sure the files to load are in the proper UNIX format by re-transferring using ASCII FTP, or by using an appropriate OS tool.
- Re-load the database.