his業務系統中病人出院結算時醫保病人是要上傳資料到前置機,病人資料多的時候總是出現程式沒有回應,但是用pbl總是好的
uj5u.com熱心網友回復：
這個問題郁悶了一個星期了uj5u.com熱心網友回復：
頂uj5u.com熱心網友回復：
會不會有的事務沒及時提交 ？uj5u.com熱心網友回復：
沒有,但用pbl運行是好的uj5u.com熱心網友回復：
資料有沒有及時commit;
可能是有的表被鎖了，表被鎖了之后其他要訪問這個表的都會進等待狀態
程式就這么卡住了。
有程式無回應的時候，去資料庫里面看一下，有沒有表鎖住了
uj5u.com熱心網友回復：
前置機全部重裝試試！uj5u.com熱心網友回復：
沒有lock,但是每次運行pbd到20%多就會沒回應,而用pbl一直都是好的uj5u.com熱心網友回復：
回復:jlwei888 前置機全部重裝試試！
:可能的原因就是用api呼叫醫保上傳資料的問題
但是用pbl運行是好的,很是奇怪和郁悶啊!
uj5u.com熱心網友回復：
pbl運行和full編譯出來pbd運行環境有什么區別,郁悶啊uj5u.com熱心網友回復：
看看資料正在執行的陳述句oracle：
監控當前資料庫誰在運行什么SQL陳述句:
SQL>SELECT osuser, username, sql_text from v$session a, v$sqltext b
where a.sql_address =b.address order by address, piece;
SqlServer
http://m76.mail.qq.com/cgi-bin/frame_html?sid=gSODUjz8G-mCQkMJ&r=d08ec1b20306869b704e1d5a7aa8332c
uj5u.com熱心網友回復：
:
謝謝 ,資料庫中的陳述句都很正常,問題是pbd運行debugbreak部分監控日志:
2009.03.18%%王建軍%%10%%1%%1%%10.00%%0%%0%%2009.03.18%%24001304%%0%%2%%25030100100%%血清總蛋白測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001305%%0%%2%%25030100200%%血清白蛋白測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001306%%0%%2%%25030300100%%血清總膽固醇測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001307%%0%%2%%25030300200%%血清甘油三酯測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001308%%0%%2%%25030300400%%血清高密度脂蛋白膽固醇測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001309%%0%%2%%25030300500%%血清低密度脂蛋白膽固醇測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001310%%0%%2%%25030300700%%血清載脂蛋白AⅠ測定%%0%%%%項%%2009.03.18%%王建軍%%8%%1%%1%%8.00%%0%%0%%2009.03.18%%24001311%%0%%2%%25030300900%%血清載脂蛋白B測定%%0%%%%項%%2009.03.18%%王建軍%%8%%1%%1%%8.00%%0%%0%%2009.03.18%%24001312%%0%%2%%25030400101%%鉀測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001313%%0%%2%%25030400201%%鈉測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001314%%0%%2%%25030400301%%氯測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001315%%0%%2%%25030400401%%鈣測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001316%%0%%2%%25030400500%%無機磷測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001317%%0%%2%%25030400600%%鎂測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001318%%0%%2%%25030700200%%肌酐測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001319%%0%%2%%25030700500%%血清尿酸測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001320%%0%%2%%25030200100%%葡萄糖測定%%0%%%%次%%2009.03.18%%王建軍%%6%%1%%1%%6.00%%0%%0%%2009.03.18%%24001321%%0%%2%%25030700102%%尿素氮測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001322%%0%%2%%25030502400%%血清亮氨酰氨基肽酶測定%%0%%%%項%%2009.03.18%%王建軍%%10%%1%%1%%10.00%%0%%0%%2009.03.18%%24001323%%0%%2%%25030200200%%血清果糖胺測定%%0%%%%項%%2009.03.18%%王建軍%%6%%1%%1%%6.00%%0%%0%%2009.03.18%%24001324%%0%%2%%25030101400%%β2微球蛋白測定%%0%%%%項%%2009.03.18%%王建軍%%20%%1%%1%%20.00%%0%%0%%2009.03.18%%24001325%%0%%2%%cl
00008704 507.09725398 [2896] 400025x%%采血器%%0%%%%只%%2009.03.18%%王建軍%%1.7%%1%%1%%1.70%%0%%0%%2009.03.18%%24001326%%0%%2%%25030200700%%血清唾液酸測定%%0%%%%項%%2009.03.18%%王建軍%%8%%1%%1%%8.00%%0%%0%%2009.03.18%%24001327%%0%%2%%25030500700%%血清丙氨酸氨基轉移酶測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24002696%%0%%1%%x05020000305%%利多卡因注射液0.1 g*1%%0.1 g*1%%%%支%%2009.03.18%%盧妙婉%%0.5%%1%%1%%0.50%%0%%0%%2009.03.18%%24002704%%0%%1%%x19000001131%%氯化鈉注射液（0.9%玻瓶）10ml*1%%10ml*1%%%%支%%2009.03.18%%盧妙婉%%0.22%%1%%1%%0.22%%0%%0%%2009.03.18%%24002750%%0%%1%%ZY0000035%%聚維酮碘溶液5% 100毫升*1瓶%%5% 100毫升*1瓶%%%%瓶%%2009.03.18%%盧妙婉%%5.3%%1%%1%%5.30%%1%%0%%2009.03.18%%24005963%%0%%2%%cl120100012x%%一次性注射器20cc%%0%%%%付%%2009.03.19%%王建軍%%1.5%%1%%1%%1.50%%0%%0%%2009.03.19%%24005964%%0%%2%%cl120100012x%%一次性注射器20cc%%0%%%%付%%2009.03.19%%王建軍%%1.5%%1%%1%%1.50%%0%%0%%2009.03.19%%24005965%%0%%2%%cl120100012x%%一次性注射器20cc%%0%%%%付%%2009.03.19%%王建軍%%1.5%%1%%1%%1.50%%0%%0%%2009.03.19%%24005966%%0%%2%%cl120400022x%%一次性輸液皮管5.5#%%0%%%%條%%2009.03.19%%王建軍%%1.3%%1%%1%%1.30%%0%%0%%2009.03.19%%24005967%%0%%2%%12040000600%%靜脈輸液%%0%%%%次%%2009.03.19%%王建軍%%2.3%%1%%1%%2.30%%0%%0%%2009.03.19%%24005968%%0%%2%%cl120100012x%%一次性注射器50cc%%0%%%%付%%2009.03.18%%王建軍%%2.5%%1%%1%%2.50%%0%%0%%2009.03.18%%24005969%%0%%2%%12040000200%%靜脈注射%%0%%%%次%%2009.03.18%%王建軍%%2.3%%1%%1%%2.30%%0%%0%%2009.03.18
00008705 507.09953332 [2896] <808>函式呼叫原型:
00008706 507.09956265 [2896] <809>f_UserBargaingApply(33,0,$$1~~~~67350 0~1800000001473~50~23999988%%0%%2%%25010100500%%網織紅細胞計數(Ret)%%0%%%%項%%2009.03.18%%王建軍%%5%%3%%1%%15.00%%0%%0%%2009.03.18%%23999989%%0%%2%%cl120400025x%%采血器%%0%%%%只%%2009.03.18%%王建軍%%1.7%%1%%1%%1.70%%0%%0%%2009.03.18%%23999990%%0%%2%%25010101500%%血常規（五分類）%%0%%%%次%%2009.03.18%%王建軍%%15%%1%%1%%15.00%%0%%0%%2009.03.18%%24000415%%0%%2%%25020302500%%活化部分凝血活酶時間測定(APTT)%%0%%%%項%%2009.03.18%%王建軍%%12%%1%%1%%12.00%%0%%0%%2009.03.18%%24000417%%0%%2%%25020303000%%血漿纖維蛋白原測定%%0%%%%項%%2009.03.18%%王建軍%%12%%1%%1%%12.00%%0%%0%%2009.03.18%%24000418%%0%%2%%25020303500%%凝血酶時間測定(TT)%%0%%%%項%%2009.03.18%%王建軍%%12%%1%%1%%12.00%%0%%0%%2009.03.18%%24000419%%0%%2%%cl120400025x%%采血器%%0%%%%只%%2009.03.18%%王建軍%%1.7%%2%%1%%3.40%%0%%0%%2009.03.18%%24000420%%0%%2%%zl000000001%%B型納尿肽定量測定(BNP)急診%%0%%%%項%%2009.03.18%%王建軍%%270%%1%%1%%270.00%%1%%0%%2009.03.18%%24000421%%0%%2%%25020302000%%血漿凝血酶原時間測定(PT)%%0%%%%項%%2009.03.18%%王建軍%%12%%1%%1%%12.00%%0%%0%%2009.03.18%%24001297%%0%%2%%25030500100%%血清總膽紅素測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24001298%%0%%2%%25030500200%%血清直接膽紅素測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24001299%%0%%2%%25030500300%%血清間接膽紅素測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24001300%%0%%2%%25030500800%%血清天門冬氨酸氨基轉移酶測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24001301%%0%%2%%25030500900%%血清γ-谷氨酰基轉移酶測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24001302%%0%%2%%25030501100%%血清堿性磷酸酶測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24001303%%0%%2%%25030501700%%血清α-L-巖藻糖苷酶測定%%0%%%%項%%2009.03.18%%王建軍%%10%%1%%1%%10.00%%0%%0%%2009.03.18%%24001304%%0%%2%%25030100100%%血清總蛋白測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001305%%0%%2%%25030100200%%血清白蛋白測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001306%%0%%2%%25030300100%%血清總膽固醇測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001307%%0%%2%%25030300200%%血清甘油三酯測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001308%%0%%2%%25030300400%%血清高密度脂蛋白膽固醇測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001309%%0%%2%%25030300500%%血清低密度脂蛋白膽固醇測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001310%%0%%2%%25030300700%%血清載脂蛋白AⅠ測定%%0%%%%項%%2009.03.18%%王建軍%%8%%1%%1%%8.00%%0%%0%%2009.03.18%%24001311%%0%%2%%25030300900%%血清載脂蛋白B測定%%0%%%%項%%2009.03.18%%王建軍%%8%%1%%1%%8.00%%0%%0%%2009.03.18%%24001312%%0%%2%%25030400101%%鉀測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001313%%0%%2%%25030400201%%鈉測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001314%%0%%2%%25030400301%%氯測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001315%%0%%2%%25030400401%%鈣測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001316%%0%%2%%25030400500%%無機磷測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001317%%0%%2%%25030400600%%鎂測定%%0%%%%項%%2009.03.18%%王建軍%%5%%1%%1%%5.00%%0%%0%%2009.03.18%%24001318%%0%%2%%25030700200%%肌酐測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001319%%0%%2%%25030700500%%血清尿酸測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001320%%0%%2%%25030200100%%葡萄糖測定%%0%%%%次%%2009.03.18%%王建軍%%6%%1%%1%%6.00%%0%%0%%2009.03.18%%24001321%%0%%2%%25030700102%%尿素氮測定%%0%%%%項%%2009.03.18%%王建軍%%4%%1%%1%%4.00%%0%%0%%2009.03.18%%24001322%%0%%2%%25030502400%%血清亮氨酰氨基肽酶測定%%0%%%%項%%2009.03.18%%王建軍%%10%%1%%1%%10.00%%0%%0%%2009.03.18%%24001323%%0%%2%%25030200200%%血清果糖胺測定%%0%%%%項%%2009.03.18%%王建軍%%6%%1%%1%%6.00%%0%%0%%2009.03.18%%24001324%%0%%2%%25030101400%%β2微球蛋白測定%%0%%%%項%%2009.03.18%%王建軍%%20%%
00008707 507.10043595 [2896] 1%%20.00%%0%%0%%2009.03.18%%24001325%%0%%2%%cl120400025x%%采血器%%0%%%%只%%2009.03.18%%王建軍%%1.7%%1%%1%%1.70%%0%%0%%2009.03.18%%24001326%%0%%2%%25030200700%%血清唾液酸測定%%0%%%%項%%2009.03.18%%王建軍%%8%%1%%1%%8.00%%0%%0%%2009.03.18%%24001327%%0%%2%%25030500700%%血清丙氨酸氨基轉移酶測定%%0%%%%項%%2009.03.18%%王建軍%%3%%1%%1%%3.00%%0%%0%%2009.03.18%%24002696%%0%%1%%x05020000305%%利多卡因注射液0.1 g*1%%0.1 g*1%%%%支%%2009.03.18%%盧妙婉%%0.5%%1%%1%%0.50%%0%%0%%2009.03.18%%24002704%%0%%1%%x19000001131%%氯化鈉注射液（0.9%玻瓶）10ml*1%%10ml*1%%%%支%%2009.03.18%%盧妙婉%%0.22%%1%%1%%0.22%%0%%0%%2009.03.18%%24002750%%0%%1%%ZY0000035%%聚維酮碘溶液5% 100毫升*1瓶%%5% 100毫升*1瓶%%%%瓶%%2009.03.18%%盧妙婉%%5.3%%1%%1%%5.30%%1%%0%%2009.03.18%%24005963%%0%%2%%cl120100012x%%一次性注射器20cc%%0%%%%付%%2009.03.19%%王建軍%%1.5%%1%%1%%1.50%%0%%0%%2009.03.19%%24005964%%0%%2%%cl120100012x%%一次性注射器20cc%%0%%%%付%%2009.03.19%%王建軍%%1.5%%1%%1%%1.50%%0%%0%%2009.03.19%%24005965%%0%%2%%cl120100012x%%一次性注射器20cc%%0%%%%付%%2009.03.19%%王建軍%%1.5%%1%%1%%1.50%%0%%0%%2009.03.19%%24005966%%0%%2%%cl120400022x%%一次性輸液皮管5.5#%%0%%%%條%%2009.03.19%%王建軍%%1.3%%1%%1%%1.30%%0%%0%%2009.03.19%%24005967%%0%%2%%12040000600%%靜脈輸液%%0%%%%次%%2009.03.19%%王建軍%%2.3%%1%%1%%2.30%%0%%0%%2009.03.19%%24005968%%0%%2%%cl120100012x%%一次性注射器50cc%%0%%%%付%%2009.03.18%%王建軍%%2.5%%1%%1%%2.50%%0%%0%%2009.03.18%%24005969%%0%%2%%12040000200%%靜脈注射%%0%%%%次%%2009.03.18%%王建軍%%2.3%%1%%1%%2.30%%0%%0%%2009.03.18~0~$$,,
(---到這里就不下去了,呼叫醫保api函式,但上用pbl正常)
00008708 508.11192540 [2896] <810>函式呼叫回傳:
00008709 508.11202122 [2896] <811>li_Ret=0
00008710 508.11293558 [2896] <812>As_OutData=https://bbs.csdn.net/topics/$$0~~0~0~~~$$
00008711 508.11301017 [2896] <813>.OutParam:
00008712 509.54030107 [2708] hncit cyb: C:\WINDOWS\624.jpg:wb
uj5u.com熱心網友回復：
頂uj5u.com熱心網友回復：
已經暈了uj5u.com熱心網友回復：
問題可能在RowsCopy()問題uj5u.com熱心網友回復：
用一行一行賦值代替rowscopy還是不行 郁悶uj5u.com熱心網友回復：
編譯成dll再試試如果不行的話，找到錯誤的地方（可以用messagebox)，然后換種思路或者方法來實作
uj5u.com熱心網友回復：
謝謝,經發現是呼叫外部函式上傳資料有問題,把外部函式上傳資料拿掉不會出現沒回應可是用pbl運行是好的...
uj5u.com熱心網友回復：
pbL 是好的,意思是在你做開發的電腦上運行正常吧.有沒有嘗試檢查檔案的完整性問題,或者在前置機上也安裝上開發環境試一試.
uj5u.com熱心網友回復：
檔案檢查應該不少,對了,在前置機上安裝上環境試試是個好主意uj5u.com熱心網友回復：
可是用pbl是好的 (郁悶)uj5u.com熱心網友回復：
陪你一起郁悶uj5u.com熱心網友回復：
整個環境移到前置機上pbd運行正常,說明1)呼叫上傳外部函式傳輸兼容性問題 2)pb太弱謝謝以上各位的分析,非常感謝wag_enu(王震宇)
uj5u.com熱心網友回復：
我覺得還是重新構思一下吧。有些時候不能單純的看你這段代碼。要從你這個功能模塊入手。
如果要說PBL是可以的。而你的PBD不可以。
我想問題可能出在你的網路鏈接上。
你可以給出問題的那臺機器單獨的弄一個事務，也就是不和別的機器重復。
那樣試試看。如果不出問題就應該是事務鏈接上沖突引起的。
uj5u.com熱心網友回復：
我覺得還是重新構思一下吧。
有些時候不能單純的看你這段代碼。要從你這個功能模塊入手。
如果要說PBL是可以的。而你的PBD不可以。
我想問題可能出在你的網路鏈接上。
你可以給出問題的那臺機器單獨的弄一個事務，也就是不和別的機器重復。
那樣試試看。如果不出問題就應該是事務鏈接上沖突引起的。
感謝zhgwbzhd的回復:
疑問:是不是根據你的做法就是在前置機上專門為一臺機器單獨弄一個事務(專門建一個網路鏈接)
,其他網路鏈接去掉
uj5u.com熱心網友回復：
是不是缺少DLL檔案???uj5u.com熱心網友回復：
api,沒有dll怎么調啊.uj5u.com熱心網友回復：
pb 6.5有個補丁的，不知道你有沒有打，名字是：PowerBuilder 6.5.1 Maintenance你可以打下試試看，
uj5u.com熱心網友回復：
你是不是裝在U盤里面，打包的時候使有些代碼沒有打包進去轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/94951.html
標籤：數據庫相關
上一篇：pb如何把圖片控制元件顯示的圖片保存到指定的服務器檔案夾上？
下一篇：PB關于呼叫SAP失敗的問題