TypeConverter
Joined: 21-May-2004
Joined: 21-May-2004
Joined: 21-May-2004
Joined: 21-May-2004
Joined: 21-May-2004
Otis wrote:
bucket.PredicateExpression.AddWithAnd(UserFields.Disabled==false);
This worked. I am on to my next bug now 
. Thanks so much for the help.
Joined: 21-May-2004
Hey again 
bucket.PredicateExpression.Add(PredicateFactory.CompareValue(ProcessFieldIndex.ProjectId, ComparisonOperator.Equal, projectId));
Is now throwing an error.
"Value isn't of type boolean"
I changed the code to this
bucket.PredicateExpression.Add(ProcessFields.ProjectId == projectId);
Still hitting the same error.
2006-03-09 12:02:42,375 [3008] ERROR WebMissionFire.Login [] - **APPLICATION ERROR - ERROR [42703] [IBM][DB2/NT] SQL0206N "ADMINISTRATOR.PROCESS.PROJECT_ID" is not valid in the context where it is used. SQLSTATE=42703
**
2006-03-09 12:02:42,375 [3008] ERROR WebMissionFire.Login [] - at IBM.Data.DB2.DB2Connection.b(IntPtr A_0, m A_1, x A_2)
at IBM.Data.DB2.DB2Command.a(CommandBehavior A_0, String A_1)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowDataTableRetrievalQuery(IRetrievalQuery queryToExecute, DbDataAdapter dataAdapterToUse, DataTable tableToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, Boolean allowDuplicates)
at MissionFire.BLL.ReportEngine.ReportEngineManager.UpcomingEvents(Int32 dias, Int32 userId, Int32 projectId) in c:\missionfiresource\missionfire\reportengine\reportenginemanager.cs:line 1426
at WebMissionFire.Project.PPOverviewTab.Page_Load(Object sender, EventArgs e) in \\192.168.1.200\c$\webmissionfire\project\ppoverviewtab.aspx.cs:line 244
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()
I don't think projectid is of type boolean, is it? 
So I think you should remove the type converter from the projectid field ?
Joined: 21-May-2004
Otis wrote:
I don't think projectid is of type boolean, is it?
I had a feeling you were going to say that
/// <summary>
/// Generates the PersistenceInfoBucket for the entity 'Process'.
/// </summary>
/// <returns>The requested, populated PersistenceInfoBucket for the entity 'Process'</returns>
private static PersistenceInfoBucket CreateProcessEntityBucket()
{
PersistenceInfoBucket toReturn = new PersistenceInfoBucket();
toReturn.AddFieldPersistenceInfo("ProcessId", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "PROCESS_ID", false, (int)DB2Type.Integer, 0, 0, 10, true, "IDENTITY_VAL_LOCAL()", null, typeof(System.Int3?)));
toReturn.AddFieldPersistenceInfo("ProcessName", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "PROCESS_NAME", false, (int)DB2Type.VarChar, 500, 0, 0, false, "", null, typeof(System.String)));
toReturn.AddFieldPersistenceInfo("ProcessDescription", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "PROCESS_DESCRIPTION", false, (int)DB2Type.VarChar, 500, 0, 0, false, "", null, typeof(System.String)));
toReturn.AddFieldPersistenceInfo("ParentProcessId", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "PARENT_PROCESS_ID", false, (int)DB2Type.Integer, 0, 0, 10, false, "", null, typeof(System.Int32)));
toReturn.AddFieldPersistenceInfo("ProjectId", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "PROJECT_ID", false, (int)DB2Type.Integer, 0, 0, 10, false, "", null, typeof(System.Int32)));
toReturn.AddFieldPersistenceInfo("ProcessStatusId", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "PROCESS_STATUS_ID", false, (int)DB2Type.Integer, 0, 0, 10, false, "", null, typeof(System.Int32)));
toReturn.AddFieldPersistenceInfo("StartDate", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "START_DATE", false, (int)DB2Type.Timestamp, 0, 0, 0, false, "", null, typeof(System.DateTime)));
toReturn.AddFieldPersistenceInfo("TargetDate", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "TARGET_DATE", false, (int)DB2Type.Timestamp, 0, 0, 0, false, "", null, typeof(System.DateTime)));
toReturn.AddFieldPersistenceInfo("Duration", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "DURATION", false, (int)DB2Type.Integer, 0, 0, 10, false, "", null, typeof(System.Int32)));
toReturn.AddFieldPersistenceInfo("UserId", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "USER_ID", false, (int)DB2Type.Integer, 0, 0, 10, false, "", null, typeof(System.Int32)));
toReturn.AddFieldPersistenceInfo("CreatedOn", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "CREATED_ON", false, (int)DB2Type.Timestamp, 0, 0, 0, false, "", null, typeof(System.DateTime)));
toReturn.AddFieldPersistenceInfo("ModifiedOn", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "MODIFIED_ON", false, (int)DB2Type.Timestamp, 0, 0, 0, false, "", null, typeof(System.DateTime)));
toReturn.AddFieldPersistenceInfo("CompletedValue", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "COMPLETED_VALUE", false, (int)DB2Type.Integer, 0, 0, 10, false, "", null, typeof(System.Int32)));
toReturn.AddFieldPersistenceInfo("EndDate", new FieldPersistenceInfo(@"ADMINISTRATOR", "PROCESS", "END_DATE", false, (int)DB2Type.Timestamp, 0, 0, 0, false, "", null, typeof(System.DateTime)));
return toReturn;
}
There isn't a converter assigned to it. I stripped out all but one of the predicates for the function and it is still throwing an error. I hate DB2's error messages 
This project started out as SQL Server. I have to get it running on DB2 and finally Oracle. It's making for a fun time .. 
Joined: 21-May-2004
I have remote debugging working with this solution now as well
DCOM Configuration screws it up after Service Pack2 is installed.
If you examine the query and the parameters send, the type of the value etc. (by enabling tracing), what exactly is send and what is thus the cause? It can also be you need to specify an alias in the predicate declaration, as you're using a typedlist...
Joined: 21-May-2004
Otis wrote:
If you examine the query and the parameters send, the type of the value etc. (by enabling tracing), what exactly is send and what is thus the cause? It can also be you need to specify an alias in the predicate declaration, as you're using a typedlist...
I created the alias in the predicate declaration and turned on tracing. This is what I am getting:
Generated Sql query:
Query: SELECT DISTINCT "Process"."PROCESS_NAME" AS "PathwayName", "Process"."PROCESS_DESCRIPTION" AS "Description", "Process"."PROCESS_ID" AS "ProcessId" FROM "ADMINISTRATOR"."PROCESS" AS "Process" WHERE ( ( "projCompare"."PROJECT_ID" = ?))
Parameter: @ProjectId1 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 0.
Joined: 21-May-2004
OK, I fixed it! 
The example I used above was a simplied version of the query I actually needed. Here is what the full query SHOULD have looked liked:
SELECT DISTINCT "ADMINISTRATOR"."PROCESS"."PROCESS_NAME" AS "PathwayName", "ADMINISTRATOR"."PROCESS"."PROCESS_DESCRIPTION" AS "Description", "ADMINISTRATOR"."PROCESS"."PROCESS_ID" AS "ProcessId" FROM (( "ADMINISTRATOR"."PROCESS" INNER JOIN "ADMINISTRATOR"."USER_PERMISSION" ON "ADMINISTRATOR"."PROCESS"."PROCESS_ID"="ADMINISTRATOR"."USER_PERMISSION"."PROCESS_ID") INNER JOIN "ADMINISTRATOR"."PROJECT" ON "ADMINISTRATOR"."PROJECT"."PROJECT_ID"="ADMINISTRATOR"."PROCESS"."PROJECT_ID") WHERE ( ( ( "ADMINISTRATOR"."PROCESS"."TARGET_DATE" BETWEEN ? AND ? OR "ADMINISTRATOR"."PROCESS"."START_DATE" BETWEEN ? AND ?) AND "ADMINISTRATOR"."USER_PERMISSION"."USER_ID" = ? AND "ADMINISTRATOR"."USER_PERMISSION"."USER_ID" = ? AND ( "ADMINISTRATOR"."PROCESS"."PROCESS_STATUS_ID" = ? OR "ADMINISTRATOR"."PROCESS"."PROCESS_STATUS_ID" = ?) AND "ADMINISTRATOR"."PROCESS"."PROJECT_ID" = ?))
Here is how the fields are being defined (Correctly)
//define the fields for the datatable
ResultsetFields fields = new ResultsetFields(3);
fields.DefineField(ProcessFieldIndex.ProcessName, 0, "PathwayName");
fields.DefineField(ProcessFieldIndex.ProcessDescription, 1, "Description");
fields.DefineField(ProcessFieldIndex.ProcessId, 2, "ProcessId");
If I use an alias such as "Process" in the field definition I am getting this as a query:
SELECT DISTINCT "Process"."PROCESS_NAME" AS "PathwayName", "Process"."PROCESS_DESCRIPTION"
...
So it looks like the error was in the alias of the field definition. Is this an error? Thanks again for your help.
Where do you set the predicate alias "projCompare"? You shouldn't.
(edit) too late
Joined: 21-May-2004
Otis wrote:
Where do you set the predicate alias "projCompare"? You shouldn't.
(edit) too late
What should I do about this?
fields.DefineField(ProcessFieldIndex.ProcessId, 3, "Late Pathways", "Process",AggregateFunction.CountDistinct);
I will end up getting this: ""Process.PROCESS_ID" is not valid in the context where it is used.
There doesn't seem to be a way to omit the alias here. 
EDIT***
fields.DefineField(ProcessFieldIndex.ProcessId, 3, "Late Pathways");
fields.DefineField(ArtifactFieldIndex.ArtifactId, 4, "Late Files");
fields[3].AggregateFunctionToApply = AggregateFunction.CountDistinct;
fields[4].AggregateFunctionToApply = AggregateFunction.Count;
Seemed to be a good work around