Kevin, What version of wIntegrate are you using? I've noticed on version 5.2 if you specify in the before box "GET-LIST" without an actual get-list name (assuming that it will pick up your most current &TEMPXXX& list) it will fail with the same error.
Gerral -----Original Message----- From: Kevin Michaelsen [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:33 PM To: [email protected] Subject: RE: [U2] wIntegrate query builder question I ran it to the screen with out any issue. I ran it to report viewer and got a timed out error. So I don't think is has to do with the dictionary items. Any other possibilities??? Kevin At 09:37 AM 2/18/2005 -0800, you wrote: >Hi Kevin, > I believe you are running into invalid dict items or dict items that >don't work in your query. It appears you were able to run the report to the >screen without a problem, is that true? In Query Builder, try changing the >output destination to "Screen" and see if it works. > I wondering if you added a dict items to the 'Items', 'Sort', and/or >'Output' fields on your Query Builder screen that may not be valid. > > What happens to me: >* For output to PC (excel), if I have a bad/non-existent dict item I get >that "QueryImport to PC failed Invalid Fields" message >* If I change the Query to go to the screen then I get a different message >for a non-existent dict item: "At #1 [SORT PARTS ABC XYZ] - Keyword 'XYZ' >not recognized" > > You can do the 'old' trial and error testing of your Query and >eliminate 1 dict item at a time until you get it working... > >Have a Great Day! > > > Paul Trebbien > > Kore Technologies, Senior Support Tech. > > "Solutions that work. People who care." > > V 858.678.0030 F 858.300.2600 W www.koretech.com > > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen >Sent: Friday, February 18, 2005 6:11 AM >To: [email protected] >Subject: [U2] wintegrate query builder question > > >I'm an end user and I've developed some queries using Query builder. I been >able to get the queries to the screen but I now I want them to be placed >into an Excel spread sheet. When I select my output to go to the pc/process >and select the program to be excel and I fire my query. I get a error >window "QueryImport to PC failed Invalid Fields". Any clues to why this is >happening? Can anyone give me places an end user can check. I'd like to >speak with some confidence before I bring it up with my overly strapped IT >department. Any help would be appreciated. > >Kevin >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
