7/1/2025 2:31:35 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Error when creating a new goup
Posted: 29 Oct 09 10:06 AM
|
Hi,
I have created a new mainform for the table 'TimeExpense' and i am trying to create a new group.
But it is showing the error "XMLSchema Node not Found: TIMEEXPENSE ".
I tried to rebuild schema by editing a mailmerge.
After that also i am getting the same error?
Any suggestion please??????????? |
|
|
|
Re: Error when creating a new goup
Posted: 19 Nov 09 8:37 AM
|
Help, i'm facing the same issue plus anothers... I am developing on MSSql.
I have made a custom table, really simple indeed. I called it AccountContract and placed 3 fields on it.
Name - String 100
Amount - Float
Left - Float
I made a new Page in AppArchitect and added the groupbuilder and all the other things.
Deployed and tested and it worked.
Maded a bundle and installed it on 3 other Saleslogix installations and they all worked.
Now i installed it on an Oracle Saleslogix Installation.
First, the Float field changed to NUMBER at the database and the Admin Data Base Manager says its a Currency 255, and can't delete the field.
I deleted the table and created it manually, and the problem persist.
Also, noticed that when i enter in web, and try to add a new group, i get the "XMLSchema Node not Found: " error.
ANY HELP PLEASE!  |
|
|
|
Re: Error when creating a new goup
Posted: 19 Nov 09 4:25 PM
|
I think i solved the problem with the XMLSchema.
1st - Delete the record "DELETE FROM PLUGIN WHERE PLUGINID='XMLSCHEMA'".
2nd - Created any field in the Admin.exe.
3rd - Enter on the web with Active Mail.
4th - Edit any Template.
XMLSchema Node Not Found SOLVED! but now i noticed problems with the Oracle being CASE SENSITIVE...
The problem is when you use the web Mail Merge, the "Specific Group" only showed some groups.
I tracked the problem to the query "SELECT FAMILY, NAME, PLUGINID FROM SYSDBA.PLUGIN WHERE (TYPE=8 OR TYPE=23) AND FAMILY IN (SELECT TABLENAME FROM SYSDBA.MM_MAINTABLE_REL WHERE CANMERGETOGROUP = 'T') ORDER BY FAMILY, NAME" because in MM_MAINTABLE_REL the TABLENAMEs are all upper case, and the FAMILYs on PLUGIN have a mixe of Upper & Lower case values.
I solved this creating a login trigger with sysdba user:
CREATE OR REPLACE FUNCTION "SYSDBA"."ISNULL" (
arg1 in VARCHAR2, arg2 in VARCHAR2
) return VARCHAR2 is
begin
return nvl(arg1,arg2);
end;
With this trigger i set the sessions to CASE INSENSITIVE, and now i can see all the Groups.
Any advice on this? |
|
|
|
Re: Error when creating a new goup
Posted: 19 Nov 09 4:29 PM
|
Sorry, that's my workarround on the ISNULL i used several times in my customizations.
The trigger is this one:
CREATE TRIGGER FIX_CASE_SENSITIVE_SESSION ON LOGON
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_COMP=ANSI';
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_SORT=BINARY_CI';
END; |
|
|
|
Re: Error when creating a new goup
Posted: 27 Jan 10 12:34 PM
|
Ok, the trigger mess something on the AppArchitect deploys, so i would like to edit the query on Sage.SalesLogix.Client.MailMerge.dll to be "SELECT FAMILY,NAME,PLUGINID FROM PLUGIN WHERE (TYPE=8 OR TYPE=23) AND UPPER(FAMILY)IN(SELECT TABLENAME FROM MM_MAINTABLE_REL WHERE CANMERGETOGROUP='T') ORDER BY FAMILY,NAME" to include the upper condition, but because of copyright it's not possible.
Hehe... i noticed it! |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|