Select statement for table PSAProjSchedRole is working in test but not working in Live.

(0) Share

Report

Posted on by Siddhant Singh

518

Hi all,

In the below code, even the data is in the table projSchedRole.ProjId matches with the data in the projTable.ProjId and projSchedRole.Worker == _worker

projSchedRole is not selecting any record.

Its working on test env. but not working in live.

Can you anyone help and tell why its not working in live env.

PSAProjSchedRole projSchedRole;

if(event == "RoleStart" || event == "RoleEnd")
    {
        select * from projSchedRole where projSchedRole.ProjId == projTable.ProjId
                                        && projSchedRole.Worker == _worker;
            if(projSchedRole)
            {
                if(projSchedRole && (event == "RoleStart" || event == "RoleEnd"))
                {
                    resourceName = HcmWorker::find(projSchedRole.Worker).name();
                }
            }
    }

Thanks and regards

Siddhant Singh

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,908 Most Valuable Professional on at

Like (0)

Report
First of all, let me format your code and remove duplicate code, so it's easier to read:

if (event == "RoleStart" || event == "RoleEnd") { PSAProjSchedRole projSchedRole; select projSchedRole where projSchedRole.ProjId == projTable.ProjId && projSchedRole.Worker == _worker; if (projSchedRole) { resourceName = HcmWorker::find(projSchedRole.Worker).name(); } }

Unfortunately there isn't much we can tell you, because it all depends on what data you have in the database (for the current company) and values of projTable.ProjId, event and _worker variables.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

HI Siddhant Singh,

Is the data of Test and Live environment exactly the same?

You can write a select statement in SSMS to compare whether there is data that meets the conditions in the Live environment

Was this reply helpful? Yes No
Siddhant Singh 518 on at

Like (0)

Report

Hi Blue Wang,

I tried the query in Live SSMS and got the output with this select query but when i am trying this on AX its not returning any value.

And also my event is coming correct and variable _worker is having right value.

Can you tell what may be the reason behind it.

Thanks and regrads

Siddhant Singh

Was this reply helpful? Yes No
Martin Dráb 237,908 Most Valuable Professional on at

Like (0)

Report

Can you show us your T-SQL code, please? People often forget to include DataAreaId in relations in T-SQL and then the result may be completely misleading.

Do you execute both T-SQL and X++ in the company context?

You said that you're sure that two of the three variables have the right value. What about the project ID?

Was this reply helpful? Yes No
Siddhant Singh 518 on at

Like (0)

Report
Hi Martin,

Yes I executed both SQL and X code in company context.

Project Id is also matching in sql. In SQL code with and without dataAreaId the output is same only.

select * from PSAPROJSCHEDROLE where PSAPROJSCHEDROLE.ProjId = 'ABC-0000**' and PSAPROJSCHEDROLE.Worker = 5637****** and PSAPROJSCHEDROLE.DATAAREAID='ABC'

Do by running full CIL will help in this case to remove this defect.

Thanks and Regards

Siddhant Singh

Was this reply helpful? Yes No
Martin Dráb 237,908 Most Valuable Professional on at

Like (0)

Report
I can think of two explanations:

One or more values are not what you expect (DataAreaId, ProjId, Worker, event).

Or the data in database isn't the same when executing your code (because there are uncommitted changes done in the same transaction).

(For completeness: I'm not taking Partition into account here, because I assume it's not the current problem.)

If you believe that everything is correct, then I suggest you get Live data to a development environment and debug code against Live data.

Compiling the Live environment shouldn't be necessary - that should have been be done when deploying code to Live. If you get into situation when it's needed, then your deployment process doesn't work correctly.

Was this reply helpful? Yes No