Problem with SSIS & AS400, Source is AS400, Dest is SQL2005
When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?
When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?
35 pts.
wrkrpyle
Hello! I am attempting to execute an automatic SAVCHGOBJ from the AS400 job scheduler each evening. At the end of each run I receive a message id of CPA0701 and associated msg of CPF3778 - not all objects saved from all libraries. My problem is that I have set up a reply to CPF3778 of "I" in the...
Hello! I am attempting to execute an automatic SAVCHGOBJ from the AS400 job scheduler each evening. At the end of each run I receive a message id of CPA0701 and associated msg of CPF3778 - not all objects saved from all libraries. My problem is that I have set up a reply to CPF3778 of "I" in the...
AS/400 PRINTING ISSUE
We have over 20 different LAN printers used to print receipts for as/400. every time a printer runs out of paper, the printer loses connection and wont print anymore. The printers have to be reset from headquarters in order to work again. any reason why this is happening? It seems the IBM printers...
We have over 20 different LAN printers used to print receipts for as/400. every time a printer runs out of paper, the printer loses connection and wont print anymore. The printers have to be reset from headquarters in order to work again. any reason why this is happening? It seems the IBM printers...
CPF5140 Driving me crazy
We have a thin client in the building next door that we use to swipe for Time & Attendance. It's been up and running fine since December 2006 without any problems. Around April 1, 2008 the session started dropping off. The system error log displayed CPF5140. It states that it could be networking,...
We have a thin client in the building next door that we use to swipe for Time & Attendance. It's been up and running fine since December 2006 without any problems. Around April 1, 2008 the session started dropping off. The system error log displayed CPF5140. It states that it could be networking,...
Error 5: Size of converted data is greater than the receiver buffer length
We have an i5 270 Machine with V5R4M0. When I tried to Start the HTTP Administration Admin Instance, The WRKACTJOB shows that Admin instance is starting, but a few seconds later Admin Instance Job ends. In the Spool of QTMHHTTP, QPJOBLOG says "Error occurred converting data. Reason 5." And...
We have an i5 270 Machine with V5R4M0. When I tried to Start the HTTP Administration Admin Instance, The WRKACTJOB shows that Admin instance is starting, but a few seconds later Admin Instance Job ends. In the Spool of QTMHHTTP, QPJOBLOG says "Error occurred converting data. Reason 5." And...
Error when executing RUNSQLSTM from CL program
I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed" Not really trying anything fancy. In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I have SELECT mstid, ...
I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed" Not really trying anything fancy. In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I have SELECT mstid, ...
as400 creating a tcpip session
When trieng to create a tcpip session using device name receiving a massage "waiting for allocation from host, creating a session without device name is o.k (o.s 4.2) thanks
When trieng to create a tcpip session using device name receiving a massage "waiting for allocation from host, creating a session without device name is o.k (o.s 4.2) thanks
iSeries Client V5R3 with sp SI28055. iSeries Navigator comes up with cwbunnav.exe error.
On a Windows XP Pro, and iSeries Client V5R3 with service pack SI28055. Navigator comes up with cwbunnav.exe error. Have installed this same version on several other Win XP Pro desktops/laptops with no problem.
On a Windows XP Pro, and iSeries Client V5R3 with service pack SI28055. Navigator comes up with cwbunnav.exe error. Have installed this same version on several other Win XP Pro desktops/laptops with no problem.
Restoring journal receivers
A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: ...
A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: ...
QDLS Maximum File Size
I get the message 'write operation beyond the maximum file size for a file in file system QDLS' with output from a ASC Sequel (*delimited). It seems to stop at 2Gb. How can I increase the maximum file size allowed in QDLS ? thanks, Brian
I get the message 'write operation beyond the maximum file size for a file in file system QDLS' with output from a ASC Sequel (*delimited). It seems to stop at 2Gb. How can I increase the maximum file size allowed in QDLS ? thanks, Brian
HTTP Server Admin Instance
We've i5 270 Machine with V5R4M0. When I tried to Start the HTTP Administration Admin Instance, The WRKACTJOB shows that Admin instance is starting, but few secound later Admin Instance Job ends. In the Spool of QTMHHTTP, QPJOBLOG says "Error occurred converting data. Reason 5." And Reason 5 is...
We've i5 270 Machine with V5R4M0. When I tried to Start the HTTP Administration Admin Instance, The WRKACTJOB shows that Admin instance is starting, but few secound later Admin Instance Job ends. In the Spool of QTMHHTTP, QPJOBLOG says "Error occurred converting data. Reason 5." And Reason 5 is...
AS400 and Windows XP64
I am trying to install the AS400 Client Access program on a workstation running Windows XP64 and I keep getting a message that says "Access Denied". Is this a problem with the version of Client Access (ver5.4) or is there some setting I need to adjust in Windows.
I am trying to install the AS400 Client Access program on a workstation running Windows XP64 and I keep getting a message that says "Access Denied". Is this a problem with the version of Client Access (ver5.4) or is there some setting I need to adjust in Windows.
Printer Problem AS/400
We have a client using AS/400 model 150 using Machine 36. We have connected a network printer through OS. EVery time they go to print a document the printer ends with message CPF1164 and ending code of 20. This cause with job ending code of 20 is 'The job exceeded end severity (ENDSEV job...
We have a client using AS/400 model 150 using Machine 36. We have connected a network printer through OS. EVery time they go to print a document the printer ends with message CPF1164 and ending code of 20. This cause with job ending code of 20 is 'The job exceeded end severity (ENDSEV job...
Logical File
I have encountered this error and didnt understand why it was coming. The error was: "Errors in DDS not allowed with specified GENLVL. " i checked with wrksplf command also but didnt help me either.
I have encountered this error and didnt understand why it was coming. The error was: "Errors in DDS not allowed with specified GENLVL. " i checked with wrksplf command also but didnt help me either.
Remove exit point programs from the register without pgm names?
We purchased a used AS/400. All the application programs were removed. We frequently receive a message, Exit Program not Processed. When I go to the register and select an exit point, there is no program or format listed. I am assuming the programs were delted when the application/user programs...
We purchased a used AS/400. All the application programs were removed. We frequently receive a message, Exit Program not Processed. When I go to the register and select an exit point, there is no program or format listed. I am assuming the programs were delted when the application/user programs...
for AS/400 V5R2
HI THIS IS BHAVESH I AM GETTING ERROR WHILE EXECUTING RDO PREPARED STATEMENT THROUGH VB6 ODBC CONECTIVITY ON AS/400 SERVER PL. NOTE THAT IT IS WHEN I HAVE CHANGED MY SERVER BOX FROM V4R5 TO V5R2 MODEL STRING FOR PREPARED STATEMENT I AM USING AS FOLLOWS Public SosRdoEnv As rdoEnvironment Public...
HI THIS IS BHAVESH I AM GETTING ERROR WHILE EXECUTING RDO PREPARED STATEMENT THROUGH VB6 ODBC CONECTIVITY ON AS/400 SERVER PL. NOTE THAT IT IS WHEN I HAVE CHANGED MY SERVER BOX FROM V4R5 TO V5R2 MODEL STRING FOR PREPARED STATEMENT I AM USING AS FOLLOWS Public SosRdoEnv As rdoEnvironment Public...
Can full magstar tapes be reported as media error during a backup?
Hello, I have recenlty been getting media errors on my magstar tapes during full backups. All libaries don't save, and no matter which tape I use, I get a media error toward the end of the library list. I was wondering if a full tape could cause this error, and how do I find out if the tape is...
Hello, I have recenlty been getting media errors on my magstar tapes during full backups. All libaries don't save, and no matter which tape I use, I get a media error toward the end of the library list. I was wondering if a full tape could cause this error, and how do I find out if the tape is...
as/400 os/400 5.4 message iD: CPD3e3e
the detail message is: start of DDM/DRDA TCP/IP server failed for reason 13
the detail message is: start of DDM/DRDA TCP/IP server failed for reason 13
AS/400 BRMS
Receiving a BRM1934 error on a DUPMEDBRM when the receiving tape drive is locked protected, the system is auto responding with "D" but I do not have an auto response for this error in my reply list so where does it come from? My operators are not catching the issus since there is no break...
Receiving a BRM1934 error on a DUPMEDBRM when the receiving tape drive is locked protected, the system is auto responding with "D" but I do not have an auto response for this error in my reply list so where does it come from? My operators are not catching the issus since there is no break...
