Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Lawson Add-Ins for Microsoft Office
Add Ins Error
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Maudie Maldonado
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5194
People Online:
Visitors:
239
Members:
0
Total:
239
Online Now:
New Topics
Dealing with Lawson / Infor
Implementing Lawson v10 with Cerner Surginet, Case Cart Picking, and Quick Adds for the OR
10/29/2024 4:20 PM
Hi Everyone, I am wondering if there is any org
Lawson S3 HR/Payroll/Benefits
Canada Tax Calculation (Federal and Provincial) Issue
10/23/2024 5:00 AM
Initially, we had problem with CPP2 calculation is
Lawson S3 HR/Payroll/Benefits
CA Section 125 401k Plan
10/22/2024 10:13 PM
Does anyone have any recommendations on how to fac
S3 Systems Administration
Running AC120 deleted records from ACMASTER table
10/22/2024 3:40 PM
We recently ran the AC120 as normal and somehow it
Lawson S3 Procurement
RQ13 Approval Info
10/17/2024 2:12 PM
When a Requisition is approved on RQ13, what table
S3 Customization/Development
Read and Write CSV file COBOL
10/9/2024 2:53 PM
Does anyone have a quik example of a program that
Infor CloudSuite
Infor OS/Cloudsuite SCIM groups
10/4/2024 2:06 PM
We are in the process of moving to the Cloudsuite
Lawson Landmark
Spreadsheet Designer Error "Unknown state selection"
9/20/2024 3:19 PM
I am looking for assistance, I am trying to upload
Lawson S3 Procurement
Adding Std Comments to all PO's
9/17/2024 7:06 PM
Does anyone know of a way to get trailing comments
Lawson S3 Procurement
Missing po info
9/4/2024 3:34 PM
We are experiencing an issue where freight account
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1369
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
User Experience
Lawson Add-Ins for Microsoft Office
Add Ins Error
Please
login
to post a reply.
9 Replies
1
Subscribed to this topic
78 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
stephanie
Veteran Member
Posts: 330
3/13/2012 4:10 PM
Can someone tell me what this addins error may mean -
Filter cannot begin with '&' or '|'
We just moved to apps v901, and queries that have never had problems are now returning this error. Seems to happen most often if I try to use criteria that is any option other than "=". I'm on the most recent add-ins version
Thanks in advance - I'm almost bald from pulling my hair out over this one!!
Greg Moeller
Veteran Member
Posts: 1498
3/13/2012 4:54 PM
Stephanie: Are you using queries built with your previous app version (900) and trying to make them work with your new 901 apps? What happens if you try and start over and build one from scratch?
stephanie
Veteran Member
Posts: 330
3/13/2012 5:09 PM
Hi Greg - I've rebuilt every darn one - no cheating!!
Greg Moeller
Veteran Member
Posts: 1498
3/13/2012 5:24 PM
I know that we had to rebuild several of ours when we upgraded.
Greg Moeller
Veteran Member
Posts: 1498
3/13/2012 5:54 PM
I know that I've seen that error before, let me check my doco.
Greg Moeller
Veteran Member
Posts: 1498
3/13/2012 6:34 PM
Sorry, Stephanie, I've looked everywhere and cannot locate a resolution for this.
Gary Padgett
Veteran Member
Posts: 90
3/13/2012 7:31 PM
Stephanie, do you see anything in IOS.log and/or webserver log files? I am curious as to what the whole string is. Or is there more stuff in the add-ins error log on the PC?
stephanie
Veteran Member
Posts: 330
3/14/2012 8:47 AM
Here is an example of the addins error log one time when I received the error -
"ACTUAL CALL STRING THAT GENERATED THE ERROR:"
"https://paywebserv.house.gov/servlet/Router/Data/Erp?PROD=STAFFPROD&FILE=PRTAXLOC&INDEX=PXLSET1&KEY=4832&COND=ACTIVE&FIELD=EMPLOYEE;EMPLOYEE%2EFULL%2DNAME;EMPLOYEE%2EEMP%2DSTATUS;DED%2DCODE;ACTIVE%2DFLAG;EMP%2DDEDUCTION%2ERES%2DCODE;EMP%2DDEDUCTION%2EEFFECT%2DDATE;EMP%2DDEDUCTION%2EEND%2DDATE&SELECT=%26DED%2DCODE%3DTSMD&OUT=CSV&DELIM=%09&NOHEADER=TRUE&OTMMAX=2&OTMDELIM=~&NEXT=TRUE&MAX=1000"
"ERROR KEY = FILTER_STARTS_WITH"
"ERROR MESSAGE = Syntax error in filter: &DED-CODE=TSMD. Filter cannot begin with '&' or '|'.
There are additional "error details" - a LOT of lines of this -
" com.lawson.ios.dig.db.DmeException: FILTER_STARTS_WITH
at com.lawson.ios.dig.db.FilterManager.parseRawFilter(FilterManager.java:298)
at com.lawson.ios.dig.db.FilterManager.
(FilterManager.java:200)
at com.lawson.ios.dig.db.DigObject.initFilterComponents(DigObject.java:799)
at com.lawson.ios.dig.db.DigObject.executeInternalRequest(DigObject.java:299)
at com.lawson.ios.dig.db.DigObject.executeRequest(DigObject.java:183)
at com.lawson.ios.dig.db.Dme.executeRequest(Dme.java:76)
at com.lawson.ios.dig.ErpDmeAgent.processRequest(ErpDmeAgent.java:114)
Do you need more? Many thanks for the efforts to assist me!!
Gary Padgett
Veteran Member
Posts: 90
3/14/2012 10:53 AM
I think the error is coming from the part where it says
&SELECT=%26DED%2DCODE%3DTSMD
I believe the %26 is what is generating the error. The field name is just DED_CODE.
Can you try this string in your browser, removing that %26?
Sherry Shimek
Advanced Member
Posts: 43
6/6/2012 2:41 PM
When we upgraded, we installed the most recent version of MS Addins and then rebuilt all of our queries to resolve this issue. It may not be necessary for every current query, but it was faster to rebuild them once with an upgraded MS Addins version and the upgraded tables instead of painfully trying to run each query.
Please
login
to post a reply.