{"id":1471,"date":"2015-02-10T17:38:49","date_gmt":"2015-02-10T15:38:49","guid":{"rendered":"http:\/\/catalinx.ro\/wordpress\/?p=1471"},"modified":"2015-02-14T13:42:47","modified_gmt":"2015-02-14T11:42:47","slug":"never-trust-the-programers","status":"publish","type":"post","link":"https:\/\/catalinx.ro\/wordpress\/?p=1471","title":{"rendered":"Never Trust the programers"},"content":{"rendered":"
<\/div>\n

Asta e prea tare sa n-o spun acum.<\/p>\n

Povestea , vietii mele \u00a0( si-a tuturor programatorilor ) , o colega pleaca in concediu si lasa totul “in regula”.<\/p>\n

<\/p>\n

I don’t think my absence make different. But if by mischance, you need information from my side, it will be a little difficult to contact me.<\/em>
\nSo I write this mail and I hope you will not need it.<\/em><\/p><\/blockquote>\n

si apoi o lista cu transporturi \u00a0si apoi…<\/p>\n

For my side, they are all in test phase, you may release it without any problem (no guarantee for correct result, but guarantee for no dump).<\/strong><\/em><\/p><\/blockquote>\n

Aham .<\/p>\n

Ultimul transport era o modificare a unui field dintr-un append pe o tabela. STPO. Gen Standard SAP.<\/p>\n

Plm , release in in quality \u00a0dimpreuna cu alte 40 de transporturi si \u00a0pac-pac in preproductie , ca asa merge. Si ciuciu. Erroare . \u00a0Ciuciu tabela STPO in DB.<\/p>\n

\"STPO1\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Checked transport, found log in conversion of the table , because some Z field in an append structure was modified from char ,4 to decimal \u00a01,2 because of some computation necessities on that field. Oau , engleza. Asa. revenind. Datele in tabela erau de forma “0,3 ” reprezentand 0.3. Asa ca \u00a0conversia s-o futut.<\/p>\n

\"STPO\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Geaba am restructurat eu tabela in ABAP , la nivel de DB nu mai exista si e tot blocata in proces.<\/p>\n

Am ramas cu optiunea de a da unlock la proces in SE14 si a incerca chestia asta <\/a>.<\/p>\n

In avans cineva ne face o copie in oracle , just in case si ne da datele. Daca merge naspa , cred ca urmeaza program in ABAP cu \u00a0upload pe tabela standard. Sau ma rog asta discutam. Recunosc ca pana aici n-am ajuns sa ma porcesc \u00a0in meseria asta, dar de ce nu?<\/p>\n

Tot ce vreau sa subliniez e “but guarantee for no dump”.<\/strong><\/em><\/p>\n

\"nodump\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Sigur , asa cum se spunea pe unde am mai lucrat , “noi nu cautam acuma vinovati ” :).\u00a0<\/strong>In sensul ca i-am gasit deja .<\/em><\/p>\n

Si pe bune greseli d-astea se pot intampla oricui , chiar daca ar trebui sa te intrebi de unele chestii cand schimbi tipul de date pe campuri, pe tabele STANDARD.<\/p>\n

Mi se pare doar funny si tot ce vreau sa spun e sa n-ai incredere in programatori.<\/p>\n

Ma rog , si ar mai fi de zis ca suntem in UAT si cuiva ii tataie curul i ma intreaba daca n-am un prieten basis ;). Gen , “de ce? angajati ? “… N-angajeaza ca au indieni…<\/p>\n

 <\/p>\n

Later Edit. Rezolvat . Mi-e lene sa scriu acu’ . Am sa scriu in 2 3 zile , dar tineti minte doua functii de baza DD_DROP_TABLE si DB_RENAME_TABLE. Ie de baza. de baza de date vreau sa zic<\/strong><\/p>\n

Postul asta va fi cu parola in curand . Momentan ma distrez.<\/p>\n","protected":false},"excerpt":{"rendered":"

Asta e prea tare sa n-o spun acum. Povestea , vietii mele \u00a0( si-a tuturor programatorilor ) , o colega pleaca in concediu si lasa…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[229],"tags":[235,238,236,237],"class_list":["post-1471","post","type-post","status-publish","format-standard","hentry","category-tech","tag-abap","tag-distrus-tabela-standard","tag-sap","tag-table-fails-in-conversion"],"views":2011,"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Eq23-nJ","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1471"}],"version-history":[{"count":6,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1471\/revisions"}],"predecessor-version":[{"id":1528,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1471\/revisions\/1528"}],"wp:attachment":[{"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/catalinx.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}