Issue with _Insert and _Update


Author
Message
Sean Kelly
Sean Kelly
StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)
Group: StrataFrame Users
Posts: 6, Visits: 61
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


Trent Taylor
Trent Taylor
StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Edhy Rijo
E
StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Edhy Rijo

Sean Kelly
Sean Kelly
StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)
Group: StrataFrame Users
Posts: 6, Visits: 61
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Ha ha!  I love it.
OK.  First, thanks.  I found the table schema... in the designer (which I've always had a healthy respect for...)

But everything is there...
But, to make sure I'm talking to the correct SPROC...
I gave a default value to the first  parameter... and the error moved on...
?ex.Message
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_DateStarted', which was not supplied."
?ex.Message
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_DateEnded', which was not supplied."
?ex.Message
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_AltOrder', which was not supplied."

So... VS is talking to the correct SPROC...  the Partial BO thinks all the fields are there...  any thoughts?


Sean Kelly
Sean Kelly
StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)
Group: StrataFrame Users
Posts: 6, Visits: 61
Edhy Rijo - 3/6/2024
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Thanks Edhy!  It's like the SF all-stars helping me out... 8^ )

I'll attach Larry's doc if needed.  It is a lengthy list of steps...

Edhy Rijo
E
StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Sean Kelly - 3/6/2024
Edhy Rijo - 3/6/2024
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Thanks Edhy!  It's like the SF all-stars helping me out... 8^ )

I'll attach Larry's doc if needed.  It is a lengthy list of steps...

Shawn,
Did you regenerate the BO from the BOM?

Edhy Rijo

Trent Taylor
Trent Taylor
StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)StrataFrame Developer (7.1K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Edhy Rijo - 3/6/2024
Sean Kelly - 3/6/2024
Edhy Rijo - 3/6/2024
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Thanks Edhy!  It's like the SF all-stars helping me out... 8^ )

I'll attach Larry's doc if needed.  It is a lengthy list of steps...

Shawn,
Did you regenerate the BO from the BOM?

I was going to have you do that very thing next, have you rebuilt the partial yet like Edhy mentione?
Sean Kelly
Sean Kelly
StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)
Group: StrataFrame Users
Posts: 6, Visits: 61
Edhy Rijo - 3/6/2024
Sean Kelly - 3/6/2024
Edhy Rijo - 3/6/2024
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Thanks Edhy!  It's like the SF all-stars helping me out... 8^ )

I'll attach Larry's doc if needed.  It is a lengthy list of steps...

Shawn,
Did you regenerate the BO from the BOM?

yes... if you mean Rebuild

Edhy Rijo
E
StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)StrataFrame VIP (2.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Trent Taylor - 3/6/2024
Edhy Rijo - 3/6/2024
Sean Kelly - 3/6/2024
Edhy Rijo - 3/6/2024
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Thanks Edhy!  It's like the SF all-stars helping me out... 8^ )

I'll attach Larry's doc if needed.  It is a lengthy list of steps...

Shawn,
Did you regenerate the BO from the BOM?

I was going to have you do that very thing next, have you rebuilt the partial yet like Edhy mentione?

Also, in my case, just opening and loading the BOM takes several minutes with the last update, so be patience.

Once you have it, locate the class corresponding to your BO, then, right click and regenerate it. Hehe

Edhy Rijo

Sean Kelly
Sean Kelly
StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)StrataFrame Beginner (9 reputation)
Group: StrataFrame Users
Posts: 6, Visits: 61
Sean Kelly - 3/6/2024
Edhy Rijo - 3/6/2024
Sean Kelly - 3/6/2024
Edhy Rijo - 3/6/2024
Trent Taylor - 3/6/2024
Sean Kelly - 3/6/2024
i recently updated my projects to VS2022 and the Strataframe "process" that goes along with it.
I apologize, in advance, if this gets a little wordy...but I want to explain where I am at.

i have an issue in my most recent project (~2018). A BO is no longer saving using the _Insert and _Update procedures...

The error:
"Procedure or function 'AlternatePosition_Insert' expects parameter '@ap_UsePrimaryJobTitle', which was not supplied."In theory, that would point to a disconnect between the DDT and the BOM, right?

I add the screen snip below to point out that 4 items are not updating/inserting properly.
They just happen to be 4 columns that I added after the table's creation.


Anyway, prior to the conversion to 2022, this BO saved fine.

And the DDT did its job...


With Larry retired, I am not as well versed in the inner machinations of Strataframe...
For instance, I wouldn't know where to look in SF to check that fields are missing from an _Insert or _Update call.

When I look in the BOM, i see the full table... but a rebuild doesn't correct the problem.

And, I have never had this issue in SF before. And I've saved many BOs without incident since 2008.
So... the fact that FOUR parameters were not being added... and the proximity to the update/upgrade made me wonder.

If this is a known issue and I'm just sleeping on it... I apologize.  I'm just stuck right now.
Again, I apologize for the wordy post (hey, i did add pictures too!). Any help you could provide me would be appreciated.

Thanks,

Sean
Santa Cruz County, CA


I enjoyed your post, the comments at the bottom regarding the pictures made me laugh.  I know that knowing the inner workings of something can make a huge difference.  The good news here is that updating to VS2022 didn't create the issue.  We've been on VS2022 for years and this in and of itself doesn't affect how the code works in relation to a BO.

A BO uses the mapped schema to fill out the required fields.  If you open up the Designer file of the BO, and go down to the CreateTableSchema method, it will show all of the columns that the BO knows about.  This gets created when you map a BO through the BO Mapper.  So before you rebuild the partial class, look and see if you have all of the fields that are appearing.  It seems to me like your BO and the SPROC are not lining up.  If they are not in the partial class of the BO, then it will not know to fill them out.


(I thought I would add a pretty image too).

Hi Trent, Sean,
Well, even though I love having pictures in my messages, but, I am loving more right now seeing this thread in the forum.
I may be wrong, but if I remember correctly, switching to VS2022 also required an updated Extensibility extension and an updated DDT as well.

Because Sean simply added 4 new columns to this table in the DDT, the DDT is the one responsible for automatically creating these system stored procedures and there may be something failing in that process.
It could also be that the BO was not regenerated from the BOM (Business Object Mapper) then the columns are not in the designer as explained by Trent.

Best!

Thanks Edhy!  It's like the SF all-stars helping me out... 8^ )

I'll attach Larry's doc if needed.  It is a lengthy list of steps...

Shawn,
Did you regenerate the BO from the BOM?

yes... if you mean Rebuild

And i should add... that Larry had me run the DDT outside of VS...  as a separate program/icon in my Start Menu...
And that the BOM is run from VS... Extensions -> Strataframe -> BOM

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search