Error JDB9900600 - Failed to store value, maximum exceeded... using F4114 Edit Line

Hi all,

I'm designing a report that call F4114 Begin Doc / Edit Line / End Doc every line read from view.

The report works well until get the 898 line, when the functions don't work anymore.

At report I got this errors:
Error: Cancel Not Allowed For 3-Way Match
Warning: Date Is In Future Fiscal Year
Warning: Item Branch Record Not Found - WARNING
Error: Item Master Record Not Found
Error: No Memory
Error: Branch/Plant Invalid

At jde.log I got this error: JDB9900600 - Failed to store value, maximum exceeded. Probable cause is forgetting to call jdeRemoveDataPtr()

I don't know if I passed wrong parameters or there's other error.

Another question, using that functions I'll use the WorkFile by default?

I'm using B7334

Thanks!!!

Re: Error JDB9900600 - Failed to store value, maximum exceeded... using F4114 Edit Line

Leandro,

The first thing you need to do is get a debug log or two. Turn debugging on in JDE.INI, run the report locally, and turn begugging on with the highest level when running the report (Advanced row exit from Version Prompting - P98305/W98305D in Xe). This will give you two debug logs to look at, the normal jdedebug.log (generally in C:\) and the report log (generally in C:\B7\PrintQueue).

Re: Error JDB9900600 - Failed to store value, maximum exceeded... using F4114 Edit Line

Check the memory allocation! Somewhere you have forget to use RemoveDataPtr. I had such situation with P42040 application, when I used this to fast update status for SalesOrder rows. I faced that pointer was allocated by not deallocated. Xe have the limitation on number of pointers that can be used in session - no more than 999.

Re: Error JDB9900600 - Failed to store value, maximum exceeded... using F4114 Edit Line

[ QUOTE ]
I faced that pointer was allocated by not deallocated. Xe have the limitation on number of pointers that can be used in session - no more than 999.

[/ QUOTE ]

I heard about this limitation, another programmer made some changes in the parameters of F4114 Begin/Edit/End Document apparently the problem was solved.

But now i'm runing the UBE and around the 6000 line the same error appeared in the JDE.LOG(JDB9900600 - Failed to store value, maximum exceeded. Probable cause is forgetting to call jdeRemoveDataPtr()). Every 500 lines of processing I use the F4114 End Document.

I'm using the MBFs, nothing more, but I believe that there is some parameter that I don't pass correctly, here is my code:

[ QUOTE ]

0197 F4114 Begin Document
UNDEFINED X cDocumentAction
VA rpt_ComputerId_CTID -> szComputerID
VA rpt_ErrorConditions_EV02 <> cErrorConditions
BC Business Unit -> szBranchPlant
VA rpt_mnContabNumLote_ICU -> mnBatchNumber
VA rpt_jdDicjBatchDate_DICJ <> jdBatchDate
VA rpt_JELNLastJELine <> mnLastJELineNumber
VA rpt_KCO_KCO <> szDocumentKeyCompany
VA rpt_DocumentType_DCT <> szDocumentType
VA rpt_mnNumeroDoc_DOC <> mnDocumentNumber
VA rpt_jdDataAtual_TRDJ <> jdGLDate
BC Date - Order/Transaction -> jdTransactionDate
VA rpt_sz_Explicacao_DL01 <> szGLExplanation


0329 F4114 Edit Line
UNDEFINED X cLineAction
VA rpt_ComputerId_CTID -> szComputerID
VA rpt_cErrosF4114_EV01 <> cErrorConditions
VA rpt_EV06RecordWritten_EV06 <> cRecordWrittenToWorkFile
VA rpt_mnNumeroLinha_atul_LNID <> mnLineNumber
VA rpt_jdDataAtual_TRDJ -> jdGLDate
VA rpt_sz_Explicacao_DL01 -> szGLExplanation
"1" -> cUpdateQuantityOnHand
UNDEFINED X cSuppressErrorMessage
VA rpt_cAllowqtd_FLAG -> cAllowQtyOverAvailable
UNDEFINED X mnParentShortItemNumber
UNDEFINED X szAccountNumber
UNDEFINED X szSubledger
UNDEFINED X cSubledgerType
UNDEFINED X szPhase
UNDEFINED X szAssetID
VA rpt_prevLNID_LNID <> mnPreviousLinenumber
UNDEFINED X szAgreementNumber
UNDEFINED X mnAgreementSupplement
UNDEFINED X cContractBalancesUpdate
UNDEFINED X mnAgreementSequence
UNDEFINED X mnTransactionLineNumber
VA rpt_cFromTo_FLAG -> cFromTo
UNDEFINED X szParentLotNumber
VA rpt_JELNLastJELine <> mnLastJELine
"1" -> cDefaultFromPrimaryLocation
"1" -> cAllowHeldLots
BC Date - Order/Transaction -> jdTransactionDate
VA rpt_DocumentType_DCT -> szDocumentType
VA rpt_jdDicjBatchDate_DICJ -> jdBatchDate
VA rpt_mnContabNumLote_ICU <> mnBatchNumber
VA rpt_EV01_BatchStat <> cBatchStatus
BC Business Unit -> szBranchPlant
UNDEFINED X szItemNumber
BC Item Number - Short -> mnShortItemNumber
VA rpt_szLocalCustoItem_LOCN <> szDisplayedLocation
VA rpt_szLocalCustoItem_LOCN <- szLocation
VA rpt_szLoteCustoItem_LOTN <> szLotNumber
BC Unit of Measure - Primary -> szTransactionUOM
VA rpt_mnQtd_UORG -> mnTransactionQty
UNDEFINED X mnTransactionUnitCost
UNDEFINED X mnExtendedAmount
"2" -> mnTransactionProcessType
UNDEFINED X mnLotPotency
UNDEFINED X szLotGrade
UNDEFINED X cLotStatusCode
UNDEFINED X jdLotExpirationDate
VA rpt_mnNumeroDoc_DOC <> mnDocumentNumber
UNDEFINED X szSupplierLotNumber
UNDEFINED X szLotDescription
UNDEFINED X szReasonCode
UNDEFINED X mnCycleCountNumber
UNDEFINED X mnTagNumber
UNDEFINED X cGetNextCountDate
VA rpt_JOBSInvJobF0911 <> mnF0911JobNumber
VA rpt_KCO_KCO <> szKeyCompany
UNDEFINED X mnConfiguredStringID
UNDEFINED X cStockingType
VA rpt_INVJOBSNUMBER_JOBS <> mnInvJobNumber
UNDEFINED X szMemoLot1
UNDEFINED X szMemoLot2
UNDEFINED X szMemoLot3
UNDEFINED X cCostEntered
UNDEFINED X mnWMSLineNumber
UNDEFINED X cAgreementSearchMethod
UNDEFINED X cMultipleAgreementFound
"1" -> cProcessJE
VA rpt_MBFVER_VER -> szGLMBFVersion
UNDEFINED X szTransactionReference


0060 F4114 End Document
"EP4114" -> szProgramID
VA rpt_mnNumeroDoc_DOC <> mnDocumentNumber
VA rpt_ComputerId_CTID -> szComputerID
"1" -> cWriteCardex
UNDEFINED X cDeleteCycleOrTag
VA rpt_DocumentType_DCT -> szDocumentType
"2.00" -> mnTransactionProcessType
VA rpt_JOBSInvJobF0911 -> mnF0911Jobnumber
VA rpt_mnContabNumLote_ICU -> mnBatchNumber
UNDEFINED X cUpdateSalesHistory
VA rpt_EV01_BatchStat -> cBatchStatus
UNDEFINED X cProcessCloseBatch
"1" -> cSummarizeF0911
VA rpt_INVJOBSNUMBER_JOBS -> mnInvJobNumber
"<Blank>" -> szEDITransactionType


0069 F4114 Clear Detail Stack
VA rpt_ComputerId_CTID -> szComputerID
UNDEFINED X mnFromLineNumber
UNDEFINED X mnThruLineNumber
UNDEFINED X cDeleteHeader
UNDEFINED X cDeleteDetail
VA rpt_DocumentType_DCT -> szDocumentType
"2" -> cProcessCloseBatch
VA rpt_BatchNumber_ICU -> mnBatchNumber
VA rpt_EV01_BatchStat -> cBatchStatus
VA rpt_JOBSInvJobF0911 <> mnF0911Jobnumber
VA rpt_INVJOBSNUMBER_JOBS <> mnInvJobNumber
0070 F0011 Update on Exit
VA rpt_mnContabNumLote_ICU <> mnBatchNumber
VA rpt_szTipoLote_ICUT <> szBatchType
VA rpt_szStatusLote_IST <> cPreviousBatchStatus
UNDEFINED X cFLAGBatchStatus
UNDEFINED X cFLAGTransactionInBalance
"1" -> cFLAGSuppressBatchControl
UNDEFINED X cOverrideMode
"1" -> cSuppressDeleteFlag


[/ QUOTE ]

I'll be grateful for any help.

Thanks