{"id":31686,"date":"2015-08-13t22:46:02","date_gmt":"2015-08-14t02:46:02","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=31686"},"modified":"2019-10-18t09:51:05","modified_gmt":"2019-10-18t13:51:05","slug":"clean-p6-pobs-table","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/","title":{"rendered":"how to clean your p6 pobs table on mssql & oracle db"},"content":{"rendered":"

in my last post i went deep on how to quickly clean pobs data from a primavera p6 xer<\/a> file using a simple text editor. and we discovered that removing pobs data from an xer file greatly improved the import time for large xer files. a big thanks to readers who left comments<\/a> on that post letting me and you know that there are some 3rd party tools (free and paid) that handle this in a more automated fashion which is good to know.<\/p>\n

so the next question is…<\/p>\n

“how is pobs data affecting primavera’s performance?”<\/p>\n

we all want our copies and versions of primavera p6<\/a> to hum along and perform well – it’s a given. slow software sucks. especially given how most p6’ers (that’s a new term i’m trying out…see if it sticks ;-] ) are power users and really put the software through some paces. when you’re working with huge complex schedules and deadlines loom, every second waiting for the software better be absolutely necessary.<\/p>\n

let’s dig into this issue of pobs data and p6’s performance then.<\/p>\n

pobs data &\u00a0<\/strong>primavera p6 performance<\/h2>\n

a bit of review first at how pobs is getting around.<\/p>\n

the pobs data cycle looks something this:<\/p>\n

we know that when a user imports an xer file that has pobs entries in it, that data populates in our primavera p6 database in the pobs table. so the more files we import that contain pobs data, the larger that pobs table will grow.\u00a0and as we export projects to xer files, a copy of some of\u00a0that pobs data moves to the file, and ends up in another primavera p6 database. eventually, as we’re finding out now, a large pobs table can have an impact on the performance of primavera p6.<\/p>\n

we already know it has an impact on exporting xer files, which takes longer. and importing an xer file with a lot of pobs data can literally take hours<\/strong> as my client reported<\/a>. this is pretty much unacceptable.<\/p>\n

does the data in the pobs table affect overall performance of p6?<\/p>\n

i don’t know. since we don’t really know how the pobs gets generated in the first place.<\/p>\n

sure we know that it gets passed around during import \/ export – and can accumulate. but what is the original source?<\/p>\n

more to come on this soon i hope…<\/p>\n

before you start<\/h2>\n

i highly recommend you make a backup of your database prior to running any sql commands. if you break something, you’ll want to have a contingency plan.<\/p>\n

how to check your pobs table data in ms sql using the command-line<\/h2>\n

if you’re using microsoft sql express<\/a> as your primavera database engine, then you might have also installed the handy microsoft sql server management studio to manage your databases. if you did, you should see it in your start->all programs list in windows. \u00a0in case you don’t have sql server management studio, you can still dig in using the sqlcmd and the command line.<\/p>\n

what we want to do here is to check the pobs table in our primavera database for entries. if it’s empty, good. if it’s not, then we’ll clean it up.<\/p>\n

1) open a command prompt in windows.<\/strong><\/p>\n

\"clean<\/p>\n

2) login to your sql express database engine with the following command:<\/strong><\/p>\n

sqlcmd -s server1\\sqlexpress -u sqluseraccount -p sqlpassword<\/code><\/p>\n

on my system, this looks something like this:<\/p>\n

sqlcmd -s localhost\\sqlexpress -u sa -p prima123vera<\/code><\/p>\n

it’s best to login with the “sa” user – hopefully you know the password. you might try “prima123vera” if you don’t – it was used in a lot in install guides.<\/p>\n

3) get a listing of databases on your system<\/strong><\/p>\n

if your login was successful, you should see a prompt that looks like “1>”. that means you’re in.<\/p>\n

let’s get a listing of all of the databases in your install. type the following at the prompt:<\/p>\n

select name from sys.databases
\ngo<\/code><\/p>\n

these are on separate lines. you should see a list of all of your databases. now let’s pick one.<\/p>\n

4) set a database to use<\/strong><\/p>\n

once you’ve identified your database name, you want to tell sql that you’ll be working inside that db. type this:<\/p>\n

use my_db_name_here
\ngo<\/code><\/p>\n

here’s what you should get in response.<\/p>\n

\"clean<\/p>\n

5) query the pobs table<\/strong><\/p>\n

to see what data is in the pobs table, let’s run this query:<\/p>\n

select * from pobs
\ngo<\/code><\/p>\n

if your result was more that 0 rows affected, like mine here, then you’ve got some data in the pobs table that will be affecting your import \/ export performance.<\/p>\n

\"use<\/p>\n

scroll down for how to clean the pobs table.<\/p>\n

how to clean\u00a0your pobs table data in ms sql using the command-line<\/h2>\n

ok, once you’re this far, the cleaning part is easy. simply run the following command<\/p>\n

delete from pobs
\ngo<\/code><\/p>\n

that’s it. you’re done and you pobs table is now empty. make sure to read the recommendations at the end of this article.<\/p>\n

\n

 <\/p>\n

how to check your pobs table in ms sql using management studio<\/h2>\n

if you’ve got microsoft sql management studio or something similar, then follow these steps to clean out your pobs table.<\/p>\n

1) login to microsoft sql management studio<\/strong><\/p>\n

make sure to login as the “sa” user using sql server authentication.<\/p>\n

\"clean<\/p>\n

2) find\u00a0the pobs table<\/strong><\/p>\n

start by finding your database in the object explorer window.<\/p>\n

\"pobsexpand the tables<\/strong> sub-entry and scroll down until your find “dbo.pobs<\/strong>” which is the pobs table. highlight the table and click the “new query<\/strong>” button on the toolbar at the top of the screen.<\/p>\n

3)\u00a0check for entries<\/strong><\/p>\n

type the following in the query window:<\/p>\n

select * from pobs<\/code><\/p>\n

click the “!\u00a0execute<\/strong>” button on the toolbar.<\/p>\n

you might an empty table or you might see a result like this:<\/p>\n

\"check<\/p>\n

how to clean\u00a0your pobs table data in ms sql using management studio<\/h2>\n

ok. if you have data, then let’s delete everything from the entire table. it’s a simple command. type:<\/p>\n

delete from pobs<\/code><\/p>\n

click execute.<\/p>\n

 <\/p>\n

how to check your pobs table data in oracle xe<\/h2>\n

if you’re using oracle database express edition 10g, aka oracle xe<\/a>, the free database that ships with primavera p6 version 8.x, then you’ll need to follow these steps to check and clean your pobs table.<\/p>\n

1) open the database home page<\/strong><\/p>\n

some versions may differ, but i have a windows program entry in my start menu called “goto database home page” under the oracle database express edition 10g folder. once you get the home page up in a browser, you’ll need to login with the appropriate user to access the proper tables.<\/p>\n

in this case, you can login with “admuser”. again hopefully you know the password.<\/p>\n

\"pobs<\/p>\n

2) run the sql command.<\/strong><\/p>\n

from here, you’ll want to access the menu on the large sql icon and choose “sql\u00a0commands -> enter command<\/strong>“.<\/p>\n

\"oracle<\/p>\n

once you’ve got a blank command-entry screen loaded, you’ll type in the following:<\/p>\n

select * from pobs<\/code><\/p>\n

then click the run<\/strong> button. you should now know if your pobs table has any data in it or not. if it does, continue on to the next section.<\/p>\n

how to clean\u00a0your pobs table data in oracle xe<\/h2>\n

in oracle xe, deleting entries from the table is very straightforward. in the sql command window, type in the following:<\/p>\n

delete from pobs<\/code><\/p>\n

your pobs table should now be empty.<\/p>\n

however, with oracle xe, it’s also necessary to disable 2 triggers by running the following sql commands – as per oracle support. run each one separately, not together, as you did the delete command.<\/p>\n

alter trigger rt_pobs disable<\/code><\/p>\n

alter trigger rt_pobs_del disable<\/code><\/p>\n

it’s pretty easy, and now it’s done.<\/p>\n

is deleting pobs data safe?<\/h2>\n

as far as we know, yes it is safe. in fact, this procedure has been recommended by oracle support in a document titled “pobs table has grown in size and affects performance with project import\/export (doc id 1967569.1)<\/a>“. since pobs data is not used inside the application, it’s safe to delete it.<\/p>\n

conclusion<\/h2>\n

i’ve done my best to outline how to safely clean your primavera p6 database regardless of which database engine you are using. i highly recommend you have a backup in place before you run any sql commands.<\/p>\n

will this fix all your pobs problems for good?<\/p>\n

probably not. since pobs data is imported into your database when you import xers files that contain pobs data<\/a>, your database may continue to accumulate pobs data. i recommend you use the scripts and processes i’ve outlined to monitor your pobs table on a monthly basis. then clean as needed.<\/p>\n

can you automate cleaning the table?<\/strong><\/p>\n

yes. for any of these database platforms, you could create a script that could be triggered to run periodically by the windows scheduler<\/a>\u00a0to run the delete command and clean the table. if you want me to write-up that procedure, leave me a comment below and i’ll gladly tackle it if there’s interest.<\/p>\n

for now, keep on planning and hoping our software gets fixed soon.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

in my last post i went deep on how to quickly clean pobs data from a primavera p6 xer file…<\/p>\n","protected":false},"author":5,"featured_media":31727,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[188],"tags":[221],"content-topics":[],"class_list":["post-31686","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-and-technology","tag-database-2"],"acf":[],"yoast_head":"\nhow to clean your p6 pobs table on mssql & oracle db<\/title>\n<meta name=\"description\" content=\"pobs data can slow primavera p6 down. learn the steps to clean out your primavera p6 pobs table, whether using mssql or oracle db.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_us\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"how to clean your p6 pobs table on mssql & oracle db\" \/>\n<meta property=\"og:description\" content=\"pobs data can slow primavera p6 down. learn the steps to clean out your primavera p6 pobs table, whether using mssql or oracle db.\" \/>\n<meta property=\"og:url\" content=\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\" \/>\n<meta property=\"og:site_name\" content=\"世界杯2022亚洲比赛时间 \" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/planacademy\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-14t02:46:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-18t13:51:05+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"335\" \/>\n\t<meta property=\"og:image:height\" content=\"224\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"michael lepage\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@askmlepage\" \/>\n<meta name=\"twitter:site\" content=\"@planacademy\" \/>\n<meta name=\"twitter:label1\" content=\"written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"michael lepage\" \/>\n\t<meta name=\"twitter:label2\" content=\"est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"article\",\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#article\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\"},\"author\":{\"name\":\"michael lepage\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/7328c7ce3db2fba80dce4df3fcab6b88\"},\"headline\":\"how to clean your p6 pobs table on mssql & oracle db\",\"datepublished\":\"2015-08-14t02:46:02+00:00\",\"datemodified\":\"2019-10-18t13:51:05+00:00\",\"mainentityofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\"},\"wordcount\":1495,\"commentcount\":19,\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg\",\"keywords\":[\"database\"],\"articlesection\":[\"software & tech\"],\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"commentaction\",\"name\":\"comment\",\"target\":[\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#respond\"]}]},{\"@type\":\"webpage\",\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\",\"url\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\",\"name\":\"how to clean your p6 pobs table on mssql & oracle db\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/#website\"},\"primaryimageofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg\",\"datepublished\":\"2015-08-14t02:46:02+00:00\",\"datemodified\":\"2019-10-18t13:51:05+00:00\",\"description\":\"pobs data can slow primavera p6 down. learn the steps to clean out your primavera p6 pobs table, whether using mssql or oracle db.\",\"breadcrumb\":{\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#breadcrumb\"},\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"readaction\",\"target\":[\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/\"]}]},{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg\",\"width\":335,\"height\":224,\"caption\":\"how to clean your pobs table in p6\"},{\"@type\":\"breadcrumblist\",\"@id\":\"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#breadcrumb\",\"itemlistelement\":[{\"@type\":\"listitem\",\"position\":1,\"name\":\"blog\",\"item\":\"\/\/www.deco-dalles.com\/\"},{\"@type\":\"listitem\",\"position\":2,\"name\":\"how to clean your p6 pobs table on mssql & oracle db\"}]},{\"@type\":\"website\",\"@id\":\"\/\/www.deco-dalles.com\/#website\",\"url\":\"\/\/www.deco-dalles.com\/\",\"name\":\"世界杯2022亚洲比赛时间 \",\"description\":\"project controls training & courses\",\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"potentialaction\":[{\"@type\":\"searchaction\",\"target\":{\"@type\":\"entrypoint\",\"urltemplate\":\"\/\/www.deco-dalles.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"propertyvaluespecification\",\"valuerequired\":true,\"valuename\":\"search_term_string\"}}],\"inlanguage\":\"en-ca\"},{\"@type\":\"organization\",\"@id\":\"\/\/www.deco-dalles.com\/#organization\",\"name\":\"世界杯2022亚洲比赛时间 \",\"url\":\"\/\/www.deco-dalles.com\/\",\"logo\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"width\":500,\"height\":159,\"caption\":\"世界杯2022亚洲比赛时间 \"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\"},\"sameas\":[\"https:\/\/www.facebook.com\/planacademy\",\"https:\/\/x.com\/planacademy\",\"https:\/\/www.linkedin.com\/company\/plan-academy\",\"https:\/\/www.youtube.com\/planacademy\"]},{\"@type\":\"person\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/7328c7ce3db2fba80dce4df3fcab6b88\",\"name\":\"michael lepage\",\"image\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec3ed456ef7b16285aca5a1f589f87e5?s=96&d=mm&r=pg\",\"contenturl\":\"https:\/\/secure.gravatar.com\/avatar\/ec3ed456ef7b16285aca5a1f589f87e5?s=96&d=mm&r=pg\",\"caption\":\"michael lepage\"},\"description\":\"michael is an avid project controls blogger and is the chief learning officer here at 世界杯2022亚洲比赛时间 . michael has taught 1000s professionals how to use project controls software like primavera p6 over the past 10 years through his online courses and tutorials. michael is a member of aace, the guild of project controls and holds his pmp certification from pmi.\",\"sameas\":[\"\/\/www.deco-dalles.com\",\"https:\/\/x.com\/askmlepage\"],\"url\":\"\/\/www.deco-dalles.com\/author\/michael-lepage\/\"}]}<\/script>\n<!-- \/ yoast seo premium plugin. -->","yoast_head_json":{"title":"how to clean your p6 pobs table on mssql & oracle db","description":"pobs data can slow primavera p6 down. learn the steps to clean out your primavera p6 pobs table, whether using mssql or oracle db.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/","og_locale":"en_us","og_type":"article","og_title":"how to clean your p6 pobs table on mssql & oracle db","og_description":"pobs data can slow primavera p6 down. learn the steps to clean out your primavera p6 pobs table, whether using mssql or oracle db.","og_url":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/","og_site_name":"世界杯2022亚洲比赛时间 ","article_publisher":"https:\/\/www.facebook.com\/planacademy","article_published_time":"2015-08-14t02:46:02+00:00","article_modified_time":"2019-10-18t13:51:05+00:00","og_image":[{"width":335,"height":224,"url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg","type":"image\/jpeg"}],"author":"michael lepage","twitter_card":"summary_large_image","twitter_creator":"@askmlepage","twitter_site":"@planacademy","twitter_misc":{"written by":"michael lepage","est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"article","@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#article","ispartof":{"@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/"},"author":{"name":"michael lepage","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/7328c7ce3db2fba80dce4df3fcab6b88"},"headline":"how to clean your p6 pobs table on mssql & oracle db","datepublished":"2015-08-14t02:46:02+00:00","datemodified":"2019-10-18t13:51:05+00:00","mainentityofpage":{"@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/"},"wordcount":1495,"commentcount":19,"publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"image":{"@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg","keywords":["database"],"articlesection":["software & tech"],"inlanguage":"en-ca","potentialaction":[{"@type":"commentaction","name":"comment","target":["\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#respond"]}]},{"@type":"webpage","@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/","url":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/","name":"how to clean your p6 pobs table on mssql & oracle db","ispartof":{"@id":"\/\/www.deco-dalles.com\/#website"},"primaryimageofpage":{"@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage"},"image":{"@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg","datepublished":"2015-08-14t02:46:02+00:00","datemodified":"2019-10-18t13:51:05+00:00","description":"pobs data can slow primavera p6 down. learn the steps to clean out your primavera p6 pobs table, whether using mssql or oracle db.","breadcrumb":{"@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#breadcrumb"},"inlanguage":"en-ca","potentialaction":[{"@type":"readaction","target":["\/\/www.deco-dalles.com\/clean-p6-pobs-table\/"]}]},{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#primaryimage","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2015\/08\/clean-pobs-table-p6-e1571406589550.jpg","width":335,"height":224,"caption":"how to clean your pobs table in p6"},{"@type":"breadcrumblist","@id":"\/\/www.deco-dalles.com\/clean-p6-pobs-table\/#breadcrumb","itemlistelement":[{"@type":"listitem","position":1,"name":"blog","item":"\/\/www.deco-dalles.com\/"},{"@type":"listitem","position":2,"name":"how to clean your p6 pobs table on mssql & oracle db"}]},{"@type":"website","@id":"\/\/www.deco-dalles.com\/#website","url":"\/\/www.deco-dalles.com\/","name":"世界杯2022亚洲比赛时间 ","description":"project controls training & courses","publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"potentialaction":[{"@type":"searchaction","target":{"@type":"entrypoint","urltemplate":"\/\/www.deco-dalles.com\/?s={search_term_string}"},"query-input":{"@type":"propertyvaluespecification","valuerequired":true,"valuename":"search_term_string"}}],"inlanguage":"en-ca"},{"@type":"organization","@id":"\/\/www.deco-dalles.com\/#organization","name":"世界杯2022亚洲比赛时间 ","url":"\/\/www.deco-dalles.com\/","logo":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","width":500,"height":159,"caption":"世界杯2022亚洲比赛时间 "},"image":{"@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/"},"sameas":["https:\/\/www.facebook.com\/planacademy","https:\/\/x.com\/planacademy","https:\/\/www.linkedin.com\/company\/plan-academy","https:\/\/www.youtube.com\/planacademy"]},{"@type":"person","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/7328c7ce3db2fba80dce4df3fcab6b88","name":"michael lepage","image":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec3ed456ef7b16285aca5a1f589f87e5?s=96&d=mm&r=pg","contenturl":"https:\/\/secure.gravatar.com\/avatar\/ec3ed456ef7b16285aca5a1f589f87e5?s=96&d=mm&r=pg","caption":"michael lepage"},"description":"michael is an avid project controls blogger and is the chief learning officer here at 世界杯2022亚洲比赛时间 . michael has taught 1000s professionals how to use project controls software like primavera p6 over the past 10 years through his online courses and tutorials. michael is a member of aace, the guild of project controls and holds his pmp certification from pmi.","sameas":["\/\/www.deco-dalles.com","https:\/\/x.com\/askmlepage"],"url":"\/\/www.deco-dalles.com\/author\/michael-lepage\/"}]}},"_links":{"self":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/31686","targethints":{"allow":["get"]}}],"collection":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/comments?post=31686"}],"version-history":[{"count":0,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/31686\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media\/31727"}],"wp:attachment":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media?parent=31686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/categories?post=31686"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/tags?post=31686"},{"taxonomy":"content-topics","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/content-topics?post=31686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}