ERP 9 4 GL error Supplier Attachment

When deleting an attachment from a supplier, we get a 4GL error. Epicor hasn’t been much help. I think the file path is wrong so we tried to edit the path and got same error.

Any ideas to get rid of this? Other suppliers are working fine. I was also able to add a different attachment to this particular supplier. Is it somewhere in the database?

Randy,
Copy the error details and share it.
This might help clarifying the cause of the issue.

4GL STOP condition: The Server application has returned an error. (7243) (7241)

Stack Trace
#ERROR!
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args)
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
at System.Xml.XmlTextReaderImpl.ParseText()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Data.DataTextReader.Read()
at System.Data.XmlDataLoader.LoadColumn(DataColumn column, Object[] foundColumns)
at System.Data.XmlDataLoader.LoadTable(DataTable table, Boolean isNested)
at System.Data.XmlDataLoader.LoadData(XmlReader reader)
at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)
at System.Data.DataSet.ReadXml(String fileName)
at Epicor.Mfg.Lib.Report.EpiCrystalPushRpt.Process(List`1 rptDocList, String dataFile, String rptFile, DataSet dtsData, Session session)
at Epicor.Mfg.Lib.Report.EpiCrystalViewer.LoadReport(Object state)

re-indexing using proenv idxbuild solved it.

Mr. Randy: Just a Heads up.

I once had an idxbuild fail on me - and it destroyed the DB. I had to restore a back.

I would suggest always:

  1. Shutdown all your appservers. Then shutdown the DB
  2. Make a backup of your DB.
  3. run the “proutil mfgys -C truncate bi”
  4. run the “proutil mfgsys -C idxbuild -TB 32 -TM 32”. Always answer “N” to the “Do you have enough space for index sorting (y/.n)”

DaveO

1 Like

Hey Dave - thanks. I didn’t do the triuncate and I answered Yes. next time I’ll follow this suggestion.