1. LEON ALEKSEYEV
  2. PowerBuilder
  3. Monday, 4 May 2020 19:06 PM UTC

Hello. My company is using GIT BitBucket. We are in process of migrating our apps to PowerBuilder 2017 R3 Build 1915 and so far do not have much luck with GIT. We are facing two issues:

(1)

The local repository PB creates, ws_objects, has somewhat odd structure that is challenging to understand.
Let’s say there is a non-visual object called mv_n_tabpage_input_funcs in the PBL named mv_nvo. What we’re seeing upon creation of local repo is the following structure:

The strange thing here is that each PBL is represented with TWO directories - mv_nvo and mv_nvo.pbl.src in this case. The mv_nvo folder, however, also has a subfolder named mv_nvo.pbl.src containing the same set of source files as the "standalone" mv_nvo.pbl.src folder.

The same? It actually was a shocking discovery that files in the two sets are of different versions!

The ones stored in the “inner” mv_nvo/mv_nvo.pbl.src  folder are up-to-date, while those in the “standalone” mv_nvo.pbl.src folder are seriously outdated. Some turned out to be approximately a year old.

Is there any explanation to this? How should we proceed? How can we ensure GIT will always have the latest file versions and won’t accidentally overwrite them with the older ones? Should we manually delete the old versions of files elsewhere before pushing to central GIT repo on the server?

(2)

For some odd reason, each app ended up having 1-3 objects (datawindows) that PB failed to add to local repository, giving a generic failure error with no details/explanations. Regenerating these dw's did not help a bit. Eventually I had to manually exclude (uncheck) them from the “add files” list in order to let the process run through. I’m attaching one of such datawindow source files, mv_dw_hsg_issue_desc.srd. Could someone look into it and hopefully tell us why this particular object could not be added to local ws_objects repo?

Thank you very much - we will greatly appreciate any help/clarifications.

LEON ALEKSEYEV Accepted Answer Pending Moderation
  1. Monday, 4 May 2020 19:34 PM UTC
  2. PowerBuilder
  3. # 1

Sorry, attachment function is failing on me so I just pasted the DW code here:

$PBExportHeader$mv_dw_hsg_issue_desc.srd
release 5;
datawindow(units=0 timer_interval=0 color=79741120 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no )
header(height=1 color="536870912" )
summary(height=1 color="536870912" )
footer(height=1 color="536870912" )
detail(height=533 color="536870912" )
table(column=(type=char(150) updatewhereclause=yes name=indenture_indenture_name dbname="indenture.indenture_name" )
 column=(type=datetime update=yes updatewhereclause=yes name=issue_mtg_current_loan_date dbname="issue.mtg_current_loan_date" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=issue_mtg_current_outstand_amt dbname="issue.mtg_current_outstand_amt" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=issue_psa1 dbname="issue.psa1" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=issue_psa2 dbname="issue.psa2" )
 column=(type=decimal(0) update=yes updatewhereclause=yes name=issue_owam dbname="issue.owam" )
 column=(type=char(5) update=yes updatewhereclause=yes name=issue_calendar dbname="issue.calendar" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=issue_mtg_loan_rate dbname="issue.mtg_loan_rate" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=issue_mtg_orig_outstand_amt dbname="issue.mtg_orig_outstand_amt" )
 column=(type=datetime update=yes updatewhereclause=yes name=issue_unused_proceeds_call_date dbname="issue.unused_proceeds_call_date" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=issue_serv_charge dbname="issue.serv_charge" )
 column=(type=char(5) update=yes updatewhereclause=yes name=issue_crosscall_type dbname="issue.crosscall_type" )
 column=(type=datetime update=yes updatewhereclause=yes name=issue_orig_loan_date dbname="issue.orig_loan_date" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=issue_period dbname="issue.period" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=issue_default_red_yield dbname="issue.default_red_yield" )
 column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=issue_issue_key dbname="issue.issue_key" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"indenture~" )  TABLE(NAME=~"issue~" ) COLUMN(NAME=~"indenture.indenture_name~") COLUMN(NAME=~"issue.mtg_current_loan_date~") COLUMN(NAME=~"issue.mtg_current_outstand_amt~") COLUMN(NAME=~"issue.psa1~") COLUMN(NAME=~"issue.psa2~") COLUMN(NAME=~"issue.owam~") COLUMN(NAME=~"issue.calendar~") COLUMN(NAME=~"issue.mtg_loan_rate~") COLUMN(NAME=~"issue.mtg_orig_outstand_amt~") COLUMN(NAME=~"issue.unused_proceeds_call_date~") COLUMN(NAME=~"issue.serv_charge~") COLUMN(NAME=~"issue.crosscall_type~") COLUMN(NAME=~"issue.orig_loan_date~") COLUMN(NAME=~"issue.period~") COLUMN(NAME=~"issue.default_red_yield~") COLUMN(NAME=~"issue.issue_key~")    JOIN (LEFT=~"indenture.indenture_key~"    OP =~"=~"RIGHT=~"issue.indenture_key~" )WHERE(    EXP1 =~"~~~"ISSUE~~~".~~~"ISSUE_KEY~~~"~"   OP =~"=~"    EXP2 =~":ran_issue_key~" ) ) ARG(NAME = ~"ran_issue_key~" TYPE = number) " update="ISSUE" updatewhere=1 updatekeyinplace=yes arguments=(("ran_issue_key", number)) )
text(band=detail alignment="0" text="Indenture"border="0" color="0" x="19" y="8" height="65" width="398"  name=indenture_indenture_name_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=1 alignment="0" tabsequence=10 border="5" color="0" x="444" y="8" height="65" width="1710" format="[general]"  name=indenture_indenture_name edit.limit=150 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Mtg Loan Rate"border="0" color="0" x="19" y="104" height="65" width="398"  name=issue_mtg_loan_rate_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=detail alignment="0" text="Orig Loan Date"border="0" color="0" x="874" y="104" height="65" width="362"  name=issue_orig_loan_date_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="0" tabsequence=30 border="5" color="0" x="1285" y="104" height="65" width="398" format="[shortdate] [time]"  name=issue_orig_loan_date edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=9 alignment="1" tabsequence=40 border="5" color="0" x="2099" y="112" height="65" width="385" format="[general]"  name=issue_mtg_orig_outstand_amt edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Orig Mtg
Outstand Amt"border="0" color="0" x="1738" y="92" height="105" width="334"  name=issue_mtg_orig_outstand_amt_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=50 border="5" color="0" x="2899" y="112" height="65" width="453" format="[shortdate] [time]"  name=issue_mtg_current_loan_date edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=8 alignment="1" tabsequence=20 border="5" color="0" x="444" y="104" height="65" width="375" format="[general]"  name=issue_mtg_loan_rate edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Current Mtg
Loan Date"border="0" color="0" x="2533" y="92" height="105" width="334"  name=issue_mtg_current_loan_date_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=detail alignment="0" text="Current Mtg
Outstand Amount"border="0" color="0" x="19" y="200" height="105" width="398"  name=issue_mtg_current_outstand_amt_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="1" tabsequence=70 border="5" color="0" x="1285" y="220" height="65" width="398" format="[general]"  name=issue_serv_charge edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="OWAM"border="0" color="0" x="1738" y="220" height="65" width="334"  name=issue_owam_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="1" tabsequence=80 border="5" color="0" x="2099" y="220" height="65" width="385" format="[general]"  name=issue_owam edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=4 alignment="1" tabsequence=90 border="5" color="0" x="2899" y="220" height="65" width="453" format="[general]"  name=issue_psa1 edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=3 alignment="1" tabsequence=60 border="5" color="0" x="444" y="220" height="65" width="375" format="[general]"  name=issue_mtg_current_outstand_amt edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="PSA 1"border="0" color="0" x="2533" y="220" height="65" width="334"  name=issue_psa1_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=detail alignment="0" text="Serv Charge"border="0" color="0" x="874" y="220" height="65" width="362"  name=issue_serv_charge_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=detail alignment="0" text="PSA 2"border="0" color="0" x="19" y="328" height="65" width="398"  name=issue_psa2_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=detail alignment="0" text="Period"border="0" color="0" x="1738" y="328" height="65" width="334"  name=issue_period_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="1" tabsequence=120 border="5" color="0" x="2099" y="328" height="65" width="385" format="[general]"  name=issue_period edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Calendar"border="0" color="0" x="2533" y="328" height="65" width="334"  name=issue_calendar_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=130 border="5" color="0" x="2899" y="328" height="65" width="453" format="[general]"  name=issue_calendar edit.limit=5 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=5 alignment="1" tabsequence=100 border="5" color="0" x="444" y="328" height="65" width="375" format="[general]"  name=issue_psa2 edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Cross Call"border="0" color="0" x="874" y="328" height="65" width="362"  name=issue_crosscall_type_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="0" tabsequence=110 border="5" color="0" x="1285" y="328" height="65" width="398" format="[general]"  name=issue_crosscall_type edit.limit=5 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Unused Proceeds
Call Date"border="0" color="0" x="19" y="416" height="105" width="398"  name=issue_unused_proceeds_call_date_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=15 alignment="1" tabsequence=150 border="5" color="0" x="1285" y="436" height="65" width="398" format="[general]"  name=issue_default_red_yield edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=10 alignment="0" tabsequence=140 border="5" color="0" x="444" y="436" height="65" width="375" format="[shortdate] [time]"  name=issue_unused_proceeds_call_date edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="0" text="Default Red Yield"border="0" color="0" x="874" y="436" height="65" width="362"  name=issue_default_red_yield_t  font.face="MS Sans Serif" font.height="-8" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.