DBohner-(db)
Legendary Poster
I have an interesting issue on an Intel / Windows system - maybe one of you have already resolved the issue and would kindly share.
A UBE uses "B4700230 - Delete or Copy Flat File" to copy an inbound file to an archive location. When the test version is run from the Developer Client, the file copy works as expected.
However, once the UBE / Version are submitted to the server, I am getting an error 1750 from the B4700230 - and I'm somewhat baffled. Oracle defines the error as "1750 - Failed to write a new flat file"
Another thing I noticed, while shopping through the Local logs and comparing against the server logs is that the Locally Run version is doing some sort of encoding / conversion - when the copy occurs.
The following snippet occurs for each line in the flat file, between the IN-> / OUT-> dumps of the function (on the Local Run, only)
"Encoding cp1252 found in cache for user DBOHNER, environment DV900, application UBEName, version DRBTEST"
The encoding does not occur on the server-side submissions.
Would this be an issue with Unicode setup or an issue with Character ID configuration on the Enterprise Server?
The only setting in P93081 is:
User - *Public
Environment - *ALL
Program ID - *Default
Version - *Default
Encoding - CP1252
Status - AV
I think I've identified that the issue is not a Permissions Issue.
Local Develop Client is 32bit Xp Machine
Enterprise Server is 2008/64bit
(db)
Any thoughts?
A UBE uses "B4700230 - Delete or Copy Flat File" to copy an inbound file to an archive location. When the test version is run from the Developer Client, the file copy works as expected.
However, once the UBE / Version are submitted to the server, I am getting an error 1750 from the B4700230 - and I'm somewhat baffled. Oracle defines the error as "1750 - Failed to write a new flat file"
Another thing I noticed, while shopping through the Local logs and comparing against the server logs is that the Locally Run version is doing some sort of encoding / conversion - when the copy occurs.
The following snippet occurs for each line in the flat file, between the IN-> / OUT-> dumps of the function (on the Local Run, only)
"Encoding cp1252 found in cache for user DBOHNER, environment DV900, application UBEName, version DRBTEST"
The encoding does not occur on the server-side submissions.
Would this be an issue with Unicode setup or an issue with Character ID configuration on the Enterprise Server?
The only setting in P93081 is:
User - *Public
Environment - *ALL
Program ID - *Default
Version - *Default
Encoding - CP1252
Status - AV
I think I've identified that the issue is not a Permissions Issue.
Local Develop Client is 32bit Xp Machine
Enterprise Server is 2008/64bit
(db)
Any thoughts?