Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem reading upload file in MI34

Go to solution
Former Member

‎2011 Feb 16 2:58 PM

0 Likes
948

I am trying to execute MI34 and keep getting message 'BDC_OPEN_GROUP, group .. is invalid'. I have tried to create my upload file in both Excel and Access and save as .txt. Neither method works. I have debugged the program and discovered that the error occurs in RM07II34 at this line 'READ DATASET DS_PHY_NAME INTO YWEWA.' . The first record it reads is fine, but the second record is blank even though I have 3 records in my file.

This is what my file looks like in AL11.


TESTBB,MI04,,,,,20110215,00000000,00000000,00000000,2011,0100001020,001,,,X,,00000000000000000,,,,000,,0000000000000000,,,000000,,0000
TESTBB,MI04,,,,,20110215,00000000,00000000,00000000,2011,0100001020,002,,,,,00000000000007000,,,,000,,0000000000000000,,,000000,,9011
TESTBB,MI04,,,,,20110215,00000000,00000000,00000000,2011,0100001020,003,,,,,00000000000177992,,,,000,,0000000000000000,,,000000,,0000

I'm using t-code CG3Z to upload the file.

Does anyone have any ideas?

Brenda

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2011 Feb 16 9:36 PM

0 Likes
795

Hi Brenda,

Maybe first check if it works in test mode. Read documentation which comes with the MI34 transaction.

Also maybe remove the comma's from your file, since the file is opened in legacy text mode. It appears to me that the data in your file is overlayed into the structure ywewa and therefore should be in one big string.

Good luck,

Robert

Edited by: RJ. Schamhart on Feb 16, 2011 1:39 PM

I am trying to execute MI34 and keep getting message 'BDC_OPEN_GROUP, group .. is invalid'. I have tried to create my upload file in both Excel and Access and save as .txt. Neither method works. I have debugged the program and discovered that the error occurs in RM07II34 at this line 'READ DATASET DS_PHY_NAME INTO YWEWA.' . The first record it reads is fine, but the second record is blank even though I have 3 records in my file.

This is what my file looks like in AL11.


TESTBB,MI04,,,,,20110215,00000000,00000000,00000000,2011,0100001020,001,,,X,,00000000000000000,,,,000,,0000000000000000,,,000000,,0000
TESTBB,MI04,,,,,20110215,00000000,00000000,00000000,2011,0100001020,002,,,,,00000000000007000,,,,000,,0000000000000000,,,000000,,9011
TESTBB,MI04,,,,,20110215,00000000,00000000,00000000,2011,0100001020,003,,,,,00000000000177992,,,,000,,0000000000000000,,,000000,,0000

I'm using t-code CG3Z to upload the file.

Does anyone have any ideas?

Brenda

Reply
2 REPLIES 2
Read only

Go to solution
Former Member

‎2011 Feb 16 9:36 PM

0 Likes
796

Hi Brenda,

Maybe first check if it works in test mode. Read documentation which comes with the MI34 transaction.

Also maybe remove the comma's from your file, since the file is opened in legacy text mode. It appears to me that the data in your file is overlayed into the structure ywewa and therefore should be in one big string.

Good luck,

Robert

Edited by: RJ. Schamhart on Feb 16, 2011 1:39 PM

Read only

Go to solution
Former Member
In response to Former Member

‎2011 Feb 17 3:09 PM

0 Likes
795

Thank you for your help. I saved my file as .txt and tried again.

I discovered that my problem was with t-code CG3Z. I wasn't using the correct file name for the Target file on the application server.

Brenda