This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Messages - changssj101ssj
หน้า: [1]
1
« เมื่อ: พฤศจิกายน 17, 2011, 22:57:28 PM »
ครับจากปัญหาดังกล่าว ทำให้การ dump ข้อมูลไม่สามารถ insert ข้อมูลเข้าตารางได้ ผมได้ทำการติดต่อกับทางศูนย์เทคฯกระทรวงสาธารณสุขแล้วครับ ได้รับคำตอบว่าเป็นเงื่อนไขของทาง สนย.ที่กำหนดให้ตารางที่มีปัญหาข้างต้นต้องมี seq ด้วยและไม่สามารถให้เป็นค่า null ได้ เมื่อทางอาจารย์ดุลย์ทราบปัญาจึงได้ทำการแก้ไข ให้แล้วจากนี้ไปจังหวัดที่ยังใช้ provis ตัดส่งข้อมูลให้กับทาง สปสช. อยู่ ให้ทำการ dump ไฟล์ดังกล่าวอีกครั้ง ก็จะสามารถ insert ข้อมูลเข้าตารางดังกล่าวได้ครับ (ขอบพระคุณ คุณเกื้อกูลด้วยครับที่กรุณาตอบ ผม ช้าง สสจ.รอ. ตัวจริงเสียงจริงครับผม)
2
« เมื่อ: พฤศจิกายน 17, 2011, 15:27:02 PM »
Table : appoint
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 25 record(s)
File appoint.txt line 1: 1048 - Column 'seq' cannot be null
File appoint.txt line 2: 1048 - Column 'seq' cannot be null
File appoint.txt line 3: 1048 - Column 'seq' cannot be null
File appoint.txt line 4: 1048 - Column 'seq' cannot be null
File appoint.txt line 5: 1048 - Column 'seq' cannot be null
File appoint.txt line 6: 1048 - Column 'seq' cannot be null
File appoint.txt line 7: 1048 - Column 'seq' cannot be null
File appoint.txt line 8: 1048 - Column 'seq' cannot be null
File appoint.txt line 9: 1048 - Column 'seq' cannot be null
File appoint.txt line 10: 1048 - Column 'seq' cannot be null
File appoint.txt line 11: 1048 - Column 'seq' cannot be null
Table : labfu
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 14 record(s)
File labfu.txt line 1: 1048 - Column 'seq' cannot be null
File labfu.txt line 2: 1048 - Column 'seq' cannot be null
File labfu.txt line 3: 1048 - Column 'seq' cannot be null
File labfu.txt line 4: 1048 - Column 'seq' cannot be null
File labfu.txt line 5: 1048 - Column 'seq' cannot be null
File labfu.txt line 6: 1048 - Column 'seq' cannot be null
File labfu.txt line 7: 1048 - Column 'seq' cannot be null
File labfu.txt line 8: 1048 - Column 'seq' cannot be null
File labfu.txt line 9: 1048 - Column 'seq' cannot be null
File labfu.txt line 10: 1048 - Column 'seq' cannot be null
File labfu.txt line 11: 1048 - Column 'seq' cannot be null
Table : women
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 877 record(s)
Errored: 0 record(s)
Table : proced
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 232 record(s)
File proced.txt line 1: 1048 - Column 'seq' cannot be null
File proced.txt line 2: 1048 - Column 'seq' cannot be null
File proced.txt line 3: 1048 - Column 'seq' cannot be null
File proced.txt line 4: 1048 - Column 'seq' cannot be null
File proced.txt line 5: 1048 - Column 'seq' cannot be null
File proced.txt line 6: 1048 - Column 'seq' cannot be null
File proced.txt line 7: 1048 - Column 'seq' cannot be null
File proced.txt line 8: 1048 - Column 'seq' cannot be null
File proced.txt line 9: 1048 - Column 'seq' cannot be null
File proced.txt line 10: 1048 - Column 'seq' cannot be null
File proced.txt line 11: 1048 - Column 'seq' cannot be null
......
Many errors occured as described in log file.
Table : drug
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 1 record(s)
Updated: 0 record(s)
Errored: 56 record(s)
File drug.txt line 2: 1048 - Column 'seq' cannot be null
File drug.txt line 3: 1048 - Column 'seq' cannot be null
File drug.txt line 4: 1048 - Column 'seq' cannot be null
File drug.txt line 5: 1048 - Column 'seq' cannot be null
File drug.txt line 6: 1048 - Column 'seq' cannot be null
File drug.txt line 7: 1048 - Column 'seq' cannot be null
File drug.txt line 8: 1048 - Column 'seq' cannot be null
File drug.txt line 9: 1048 - Column 'seq' cannot be null
File drug.txt line 10: 1048 - Column 'seq' cannot be null
File drug.txt line 11: 1048 - Column 'seq' cannot be null
File drug.txt line 12: 1048 - Column 'seq' cannot be null
......
Many errors occured as described in log file.
Table : ncdscreen
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 10 record(s)
File ncdscreen.txt line 1: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 2: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 3: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 4: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 5: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 6: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 7: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 8: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 9: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 10: 1048 - Column 'seq' cannot be null
3
« เมื่อ: พฤศจิกายน 17, 2011, 15:21:05 PM »
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 25 record(s)
File appoint.txt line 1: 1048 - Column 'seq' cannot be null
File appoint.txt line 2: 1048 - Column 'seq' cannot be null
File appoint.txt line 3: 1048 - Column 'seq' cannot be null
File appoint.txt line 4: 1048 - Column 'seq' cannot be null
File appoint.txt line 5: 1048 - Column 'seq' cannot be null
File appoint.txt line 6: 1048 - Column 'seq' cannot be null
File appoint.txt line 7: 1048 - Column 'seq' cannot be null
File appoint.txt line 8: 1048 - Column 'seq' cannot be null
File appoint.txt line 9: 1048 - Column 'seq' cannot be null
File appoint.txt line 10: 1048 - Column 'seq' cannot be null
File appoint.txt line 11: 1048 - Column 'seq' cannot be null
Table : labfu
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 14 record(s)
File labfu.txt line 1: 1048 - Column 'seq' cannot be null
File labfu.txt line 2: 1048 - Column 'seq' cannot be null
File labfu.txt line 3: 1048 - Column 'seq' cannot be null
File labfu.txt line 4: 1048 - Column 'seq' cannot be null
File labfu.txt line 5: 1048 - Column 'seq' cannot be null
File labfu.txt line 6: 1048 - Column 'seq' cannot be null
File labfu.txt line 7: 1048 - Column 'seq' cannot be null
File labfu.txt line 8: 1048 - Column 'seq' cannot be null
File labfu.txt line 9: 1048 - Column 'seq' cannot be null
File labfu.txt line 10: 1048 - Column 'seq' cannot be null
File labfu.txt line 11: 1048 - Column 'seq' cannot be null
Table : proced
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 232 record(s)
File proced.txt line 1: 1048 - Column 'seq' cannot be null
File proced.txt line 2: 1048 - Column 'seq' cannot be null
File proced.txt line 3: 1048 - Column 'seq' cannot be null
File proced.txt line 4: 1048 - Column 'seq' cannot be null
File proced.txt line 5: 1048 - Column 'seq' cannot be null
File proced.txt line 6: 1048 - Column 'seq' cannot be null
File proced.txt line 7: 1048 - Column 'seq' cannot be null
File proced.txt line 8: 1048 - Column 'seq' cannot be null
File proced.txt line 9: 1048 - Column 'seq' cannot be null
File proced.txt line 10: 1048 - Column 'seq' cannot be null
File proced.txt line 11: 1048 - Column 'seq' cannot be null
......
Many errors occured as described in log file.
Table : drug
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 1 record(s)
Updated: 0 record(s)
Errored: 56 record(s)
File drug.txt line 2: 1048 - Column 'seq' cannot be null
File drug.txt line 3: 1048 - Column 'seq' cannot be null
File drug.txt line 4: 1048 - Column 'seq' cannot be null
File drug.txt line 5: 1048 - Column 'seq' cannot be null
File drug.txt line 6: 1048 - Column 'seq' cannot be null
File drug.txt line 7: 1048 - Column 'seq' cannot be null
File drug.txt line 8: 1048 - Column 'seq' cannot be null
File drug.txt line 9: 1048 - Column 'seq' cannot be null
File drug.txt line 10: 1048 - Column 'seq' cannot be null
File drug.txt line 11: 1048 - Column 'seq' cannot be null
File drug.txt line 12: 1048 - Column 'seq' cannot be null
......
Many errors occured as described in log file.
Table : ncdscreen
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Inserted: 0 record(s)
Updated: 0 record(s)
Errored: 10 record(s)
File ncdscreen.txt line 1: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 2: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 3: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 4: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 5: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 6: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 7: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 8: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 9: 1048 - Column 'seq' cannot be null
File ncdscreen.txt line 10: 1048 - Column 'seq' cannot be null
หน้า: [1]
แสดงกระทู้