New record can not be added

425 pts.
Tags:
IBM iSeries
Norwat system
We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?

Software/Hardware used:
norwat ticketing system

Answer Wiki

Thanks. We'll let you know when a new response is added.

no i dont have source code

Discuss This Question: 25  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...no new message to expand files any help   If there are no messages, then no help can be offerred. You need to contact the vendor of the "norwat ticketing system". It's a product that needs support from the vendor.   The help you can get from here is a recommendation to report the problem to the Support group for the product.   Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    The software vendor may have limits as to the database size. There may be some info in their documentation if you have it or if they have a web site, check their forums, you may find help there. If not, you most likely will have to call them like Tom said.
    11,245 pointsBadges:
    report
  • aceofdelts
    You could do a CHGPF and define the Member Size values to something appropriate for your needs. I recommend against *Nomax since that'd potentially let a runaway job take down your system.
    1,930 pointsBadges:
    report
  • abar1
    No support to the application  the company was in Canada and it was closed.i used chgpf and changed files size to nomax... But i leave the maximum number of members as it is "1" The same message "performance (record) was not added .
    425 pointsBadges:
    report
  • TomLiotta
    The same message “performance (record) was not added .   So there is a message.   Where do you see it? If it's on an application display, what does the [Help] for the message say? What shows in the joblog before this message?   Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    No support!  Do you have source code for the application?
    49,960 pointsBadges:
    report
  • abar1
    no i dont have source code
    425 pointsBadges:
    report
  • abar1
    no change in the job log ,,, it is just a message in the same application screen saying performance was not added no help
    425 pointsBadges:
    report
  • philpl1jb
    If you could get to that point in debug mode provided the programs were compiled so debug is available. You might be able to determine what/where the error is. 
    49,960 pointsBadges:
    report
  • ToddN2000
    The same message “performance (record) was not added How do we know the file is full and the record is not in error ?We have databases where if you are tring to insert a field (via SQL) from a web service where a field has data that exceeds the i-Series defined field size the insert fails.Check the inbound data for abnormalities or special chars as well we have users that like to use ALT+ chars and that crashes or data.Error message is a little vague.
    11,245 pointsBadges:
    report
  • philpl1jb
    Is this a continuation of your earlier problems with "reorg"?
    49,960 pointsBadges:
    report
  • abar1
    nope it doesn't related to reorg problem ,,, reorg , i fixed everything by moving files from a saved library ... it worked for a while but it gives me this message "record was not added" but a message sent to message Q that a file need to be expanded ( c i 9999)  for different  2 files i answered 9999 it worked for a while then  it gave me again "record was not added" but without sending any message to message Q
    425 pointsBadges:
    report
  • philpl1jb
    So, perhaps it is member sizeIf you issue the commend dspfd fore each file. You will find the rules for the initial number of records and number of increments that can be added and you will find the number of records and the number of deleted records.   If the total of the records and deleted records is = the allowed number of records then you will need to use CHGPF to allow more records.   If you have a large number of files some of these steps can be automated. 
    49,960 pointsBadges:
    report
  • TomLiotta
    With no explanation why the record wasn't added, we can't know if anything can be done about it. Part of the problem is that the "message" seems to be an application message, perhaps impromptu. There is no way to track back from the message to a cause.   It might be member size; it might be a range error (numeric range? date range?); it might be an invalid code; it might be a key mismatch or duplicate key; it could be expired or invalid license; it could be a referential constraint... it could even be a damaged object. It could be unrelated to the file itself but rather some secondary element. It could be from anything imagineable that program logic can implement.   The second problem is that it's hard to get answers when we ask questions. The first and simplest question hasn't been answered yet: Where do you see the message?   Most likely it's somewhere on a display screen. Where? In a message subfile? If so, is it the only message or can other messages be seen by scrolling?   We need to know details.   Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Norwat is gone but perhaps there are still users or previous users with expertise or documentation or some technical support.  These users would be in the same associations that your organization is in.  You should try to track them down. You should be contacting current application providers and appealling to them for a grant or loan of software to keep you running until funding can be found.
    49,960 pointsBadges:
    report
  • abar1
    IN fact i solved this problem my replace the whole library to older copy ... but i am sure i will face the same problem soon again ... Just one more thing ,,, when i open the addition form and try to add new record it say record not added .. is there away to know the files related to this addition form ... someone told me there is a query to know the files that this form add records to it
    425 pointsBadges:
    report
  • TomLiotta
    is there away to know the files related to this addition form   Assuming we know what a "form" is, you can possibly run DSPJOB against the job that is attempting to add the record. Option 14 from the 'Display Job' menu will list any open files. If the program that displays the form is also the program that updates any database files, then the list of files might give names. You can also run DSPPGMREF against involved programs to see if files are listed.   It's not clear what good that will do. Since you restored the library, you can already get a list of database fles. Unfortunately, if we don't know why records aren't added, we don't know what to do with any files.   The joblog messages from the job that fails to add records are needed.   Tom
    125,585 pointsBadges:
    report
  • abar1
    IN FACT . i could get the list of files that the addition form add data to it .. i changed initial number of records to NOMAX
    425 pointsBadges:
    report
  • abar1
    IN FACT . i could get the list of files that the addition form add data to them .. i changed initial number of records to NOMAX, and maximum member to NOMAX , i did that to all these files but i still have the problem
    425 pointsBadges:
    report
  • TomLiotta
    That's because the quantity of records is not what the problem is. But we don't know the problem. We don't know why a record isn't added. It's more likely related to some element of referential integrity or basic business rules. The integrity rules might encapsulated in the database definition or in program logic. A business rule might prevent a record being added because some flag in a control record is set the wrong way. No matter what, the place for us to look is the joblog messages. Even if the problem isn't explained there, other message elements can tell us other places to look. Until then, there are no hints. -- Tom
    125,585 pointsBadges:
    report
  • abar1
    The messages for expanding some files appeared before and i answered it 9999 and it worked for a while ... so i am asking is there a limitation to expand physical files... if so , is there a way to increase this limitation
    425 pointsBadges:
    report
  • TomLiotta
    If the files are set for *NOMAX, there is no additional expansion. The *NOMAX value tells the system to allow as many records as a physical file can hold. A single file member can hold 4 billion records. Have you added that many? -- Tom
    125,585 pointsBadges:
    report
  • abar1
    of course no i didn't add that many :) i am just trying to find a solution so the only way is to wait for a message telling me what is happening
    425 pointsBadges:
    report
  • MDratwa
    Since you changed the member/record limit to "*nomax", that is not the problem.  Could there be a numeric key value for each record and you have reached the max value???  There could be a control record or data area with a max limit of records that could be stopping you. 
    785 pointsBadges:
    report
  • abar1
    i made a copy of the application library ,,, make reorganize after closing all order entry files and end all active jobs it deleted all the marked records without destroying any files  data and i could add new records
    425 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following