Error in opening entity OrderHeaderandPayment

[jaiser roney]

Hello,

When i try to open entity  OrderHeaderandPayment  (as i used Microsoft SQL
Enterprise Manager Version: 8.0 as database  ) from webtools in ofbiz i got
the following error

javax.servlet.ServletException: javax.servlet.jsp.JspException: SQL
Exception while executing the following:SELECT OH.STATUS_ID AS STATUS_ID,
OH.ORDER_TYPE_ID AS ORDER_TYPE_ID, ORR.PARTY_ID AS PARTY_ID,
PM.PAYMENT_METHOD_TYPE_ID AS PAYMENT_METHOD_TYPE_ID, CC.PAYMENT_METHOD_ID AS
PAYMENT_METHOD_ID, CC.CARD_TYPE AS CARD_TYPE, CC.CARD_NUMBER AS CARD_NUMBER,
CC.CVV_NUMBER AS CVV_NUMBER, CC.VALID_FROM_DATE AS VALID_FROM_DATE,
CC.EXPIRE_DATE AS EXPIRE_DATE, CC.ISSUE_NUMBER AS ISSUE_NUMBER,
CC.COMPANY_NAME_ON_CARD AS COMPANY_NAME_ON_CARD, CC.TITLE_ON_CARD AS
TITLE_ON_CARD, CC.FIRST_NAME_ON_CARD AS FIRST_NAME_ON_CARD,
CC.MIDDLE_NAME_ON_CARD AS MIDDLE_NAME_ON_CARD, CC.LAST_NAME_ON_CARD AS
LAST_NAME_ON_CARD, CC.SUFFIX_ON_CARD AS SUFFIX_ON_CARD,
CC.CONTACT_MECH_IDAS CONTACT_MECH_ID,
CC.CONSECUTIVE_FAILED_AUTHS AS CONSECUTIVE_FAILED_AUTHS,
CC.LAST_FAILED_AUTH_DATE AS LAST_FAILED_AUTH_DATE, PA.TO_NAME AS TO_NAME,
PA.ATTN_NAME AS ATTN_NAME, PA.ADDRESS1 AS ADDRESS1, PA.ADDRESS2 AS ADDRESS2,
PA.DIRECTIONS AS DIRECTIONS, PA.CITY AS CITY, PA.POSTAL_CODE AS POSTAL_CODE,
PA.POSTAL_CODE_EXT AS POSTAL_CODE_EXT, PA.COUNTRY_GEO_ID AS COUNTRY_GEO_ID,
PA.STATE_PROVINCE_GEO_ID AS STATE_PROVINCE_GEO_ID, PA.COUNTY_GEO_ID AS
COUNTY_GEO_ID, PA.POSTAL_CODE_GEO_ID AS POSTAL_CODE_GEO_ID, ORR.ORDER_ID AS
ORDER_ID, ORR.ROLE_TYPE_ID AS ROLE_TYPE_ID, OH.ORDER_NAME AS ORDER_NAME,
OH.EXTERNAL_ID AS EXTERNAL_ID, OH.SALES_CHANNEL_ENUM_ID AS
SALES_CHANNEL_ENUM_ID, OH.ORDER_DATE AS ORDER_DATE, OH.ENTRY_DATE AS
ENTRY_DATE, OH.VISIT_ID AS VISIT_ID, OH.CREATED_BY AS CREATED_BY,
OH.FIRST_ATTEMPT_ORDER_ID AS FIRST_ATTEMPT_ORDER_ID, OH.CURRENCY_UOM AS
CURRENCY_UOM, OH.SYNC_STATUS_ID AS SYNC_STATUS_ID, OH.BILLING_ACCOUNT_ID AS
BILLING_ACCOUNT_ID, OH.ORIGIN_FACILITY_ID AS ORIGIN_FACILITY_ID,
OH.WEB_SITE_ID AS WEB_SITE_ID, OH.PRODUCT_STORE_ID AS PRODUCT_STORE_ID,
OH.TERMINAL_ID AS TERMINAL_ID, OH.TRANSACTION_ID AS TRANSACTION_ID,
OH.AUTO_ORDER_SHOPPING_LIST_ID AS AUTO_ORDER_SHOPPING_LIST_ID,
OH.NEEDS_INVENTORY_ISSUANCE AS NEEDS_INVENTORY_ISSUANCE, OH.IS_RUSH_ORDER AS
IS_RUSH_ORDER, OH.INTERNAL_CODE AS INTERNAL_CODE, OH.REMAINING_SUB_TOTAL AS
REMAINING_SUB_TOTAL, OH.GRAND_TOTAL AS GRAND_TOTAL, OH.PROM_TYPE AS
PROM_TYPE, OH.WEAR_DATE AS WEAR_DATE, OH.GRAD_DATE AS GRAD_DATE,
OH.LINK_SHARE_SITE_ID AS LINK_SHARE_SITE_ID, PM.GL_ACCOUNT_ID AS
GL_ACCOUNT_ID, PM.DESCRIPTION AS DESCRIPTION, PM.FROM_DATE AS FROM_DATE,
PM.THRU_DATE AS THRU_DATE, PE.SALUTATION AS SALUTATION, PE.FIRST_NAME AS
FIRST_NAME, PE.MIDDLE_NAME AS MIDDLE_NAME, PE.LAST_NAME AS LAST_NAME,
PE.PERSONAL_TITLE AS PERSONAL_TITLE, PE.SUFFIX AS SUFFIX, PE.NICKNAME AS
NICKNAME, PE.FIRST_NAME_LOCAL AS FIRST_NAME_LOCAL, PE.LAST_NAME_LOCAL AS
LAST_NAME_LOCAL, PE.MEMBER_ID AS MEMBER_ID, PE.GENDER AS GENDER,
PE.BIRTH_DATE AS BIRTH_DATE, PE.HEIGHT AS HEIGHT, PE.WEIGHT AS WEIGHT,
PE.MOTHERS_MAIDEN_NAME AS MOTHERS_MAIDEN_NAME, PE.MARITAL_STATUS AS
MARITAL_STATUS, PE.SOCIAL_SECURITY_NUMBER AS SOCIAL_SECURITY_NUMBER,
PE.PASSPORT_NUMBER AS PASSPORT_NUMBER, PE.PASSPORT_EXPIRE_DATE AS
PASSPORT_EXPIRE_DATE, PE.TOTAL_YEARS_WORK_EXPERIENCE AS
TOTAL_YEARS_WORK_EXPERIENCE, PE.COMMENTS AS COMMENTS,
PE.EMPLOYMENT_STATUS_ENUM_ID AS EMPLOYMENT_STATUS_ENUM_ID,
PE.RESIDENCE_STATUS_ENUM_ID AS RESIDENCE_STATUS_ENUM_ID, PE.OCCUPATION AS
OCCUPATION, PE.YEARS_WITH_EMPLOYER AS YEARS_WITH_EMPLOYER,
PE.MONTHS_WITH_EMPLOYER AS MONTHS_WITH_EMPLOYER, PE.DATE_OF_EVENT AS
DATE_OF_EVENT, PE.EVENT_TYPE AS EVENT_TYPE, PE.GRADUATION_YEAR AS
GRADUATION_YEAR, OCM.CONTACT_MECH_PURPOSE_TYPE_ID AS
CONTACT_MECH_PURPOSE_TYPE_ID FROM ((((dbo.PAYMENT_METHOD PM INNER JOIN
dbo.ORDER_ROLE ORR ON PM.PARTY_ID = ORR.PARTY_ID) INNER JOIN
dbo.ORDER_CONTACT_MECH OCM ON ORR.ORDER_ID = OCM.ORDER_ID) INNER JOIN
dbo.POSTAL_ADDRESS PA ON OCM.CONTACT_MECH_ID = PA.CONTACT_MECH_ID) INNER
JOIN dbo.PERSON PE ON ORR.PARTY_ID = PE.PARTY_ID) INNER JOIN
dbo.ORDER_HEADER OH ON ORR.ORDER_ID = OH.ORDER_ID, dbo.CREDIT_CARD CC (*Could
not allocate space for object 'dbo.CWT'.'CWT_PrimaryKey' in database
'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by
deleting unneeded files, dropping objects in the filegroup, adding
additional files to the filegroup, or setting autogrowth on for existing
files in the filegroup.)
*

I wanted to ask that is the problem is related with

1)  JVM heap size that set as        low 256m   high 512m
OR
2) with the physical memory of the datase drive   as my drive have a little
free space left

are both the reasons ??
what's the sol??

Please Help

[BJ Freeman]

not familiar with this version of ms sQl
but this is a Database problem.
not sure where to find it but you need to set the autogrow on
you also might look at disk space.


jaiser roney sent the following on 11/17/2007 6:49 AM:

> Hello,
>
> When i try to open entity  OrderHeaderandPayment  (as i used Microsoft SQL
> Enterprise Manager Version: 8.0 as database  ) from webtools in ofbiz i got
> the following error
>
> javax.servlet.ServletException: javax.servlet.jsp.JspException: SQL
> Exception while executing the following:SELECT OH.STATUS_ID AS STATUS_ID,
> OH.ORDER_TYPE_ID AS ORDER_TYPE_ID, ORR.PARTY_ID AS PARTY_ID,
> PM.PAYMENT_METHOD_TYPE_ID AS PAYMENT_METHOD_TYPE_ID, CC.PAYMENT_METHOD_ID AS
> PAYMENT_METHOD_ID, CC.CARD_TYPE AS CARD_TYPE, CC.CARD_NUMBER AS CARD_NUMBER,
> CC.CVV_NUMBER AS CVV_NUMBER, CC.VALID_FROM_DATE AS VALID_FROM_DATE,
> CC.EXPIRE_DATE AS EXPIRE_DATE, CC.ISSUE_NUMBER AS ISSUE_NUMBER,
> CC.COMPANY_NAME_ON_CARD AS COMPANY_NAME_ON_CARD, CC.TITLE_ON_CARD AS
> TITLE_ON_CARD, CC.FIRST_NAME_ON_CARD AS FIRST_NAME_ON_CARD,
> CC.MIDDLE_NAME_ON_CARD AS MIDDLE_NAME_ON_CARD, CC.LAST_NAME_ON_CARD AS
> LAST_NAME_ON_CARD, CC.SUFFIX_ON_CARD AS SUFFIX_ON_CARD,
> CC.CONTACT_MECH_IDAS CONTACT_MECH_ID,
> CC.CONSECUTIVE_FAILED_AUTHS AS CONSECUTIVE_FAILED_AUTHS,
> CC.LAST_FAILED_AUTH_DATE AS LAST_FAILED_AUTH_DATE, PA.TO_NAME AS TO_NAME,
> PA.ATTN_NAME AS ATTN_NAME, PA.ADDRESS1 AS ADDRESS1, PA.ADDRESS2 AS ADDRESS2,
> PA.DIRECTIONS AS DIRECTIONS, PA.CITY AS CITY, PA.POSTAL_CODE AS POSTAL_CODE,
> PA.POSTAL_CODE_EXT AS POSTAL_CODE_EXT, PA.COUNTRY_GEO_ID AS COUNTRY_GEO_ID,
> PA.STATE_PROVINCE_GEO_ID AS STATE_PROVINCE_GEO_ID, PA.COUNTY_GEO_ID AS
> COUNTY_GEO_ID, PA.POSTAL_CODE_GEO_ID AS POSTAL_CODE_GEO_ID, ORR.ORDER_ID AS
> ORDER_ID, ORR.ROLE_TYPE_ID AS ROLE_TYPE_ID, OH.ORDER_NAME AS ORDER_NAME,
> OH.EXTERNAL_ID AS EXTERNAL_ID, OH.SALES_CHANNEL_ENUM_ID AS
> SALES_CHANNEL_ENUM_ID, OH.ORDER_DATE AS ORDER_DATE, OH.ENTRY_DATE AS
> ENTRY_DATE, OH.VISIT_ID AS VISIT_ID, OH.CREATED_BY AS CREATED_BY,
> OH.FIRST_ATTEMPT_ORDER_ID AS FIRST_ATTEMPT_ORDER_ID, OH.CURRENCY_UOM AS
> CURRENCY_UOM, OH.SYNC_STATUS_ID AS SYNC_STATUS_ID, OH.BILLING_ACCOUNT_ID AS
> BILLING_ACCOUNT_ID, OH.ORIGIN_FACILITY_ID AS ORIGIN_FACILITY_ID,
> OH.WEB_SITE_ID AS WEB_SITE_ID, OH.PRODUCT_STORE_ID AS PRODUCT_STORE_ID,
> OH.TERMINAL_ID AS TERMINAL_ID, OH.TRANSACTION_ID AS TRANSACTION_ID,
> OH.AUTO_ORDER_SHOPPING_LIST_ID AS AUTO_ORDER_SHOPPING_LIST_ID,
> OH.NEEDS_INVENTORY_ISSUANCE AS NEEDS_INVENTORY_ISSUANCE, OH.IS_RUSH_ORDER AS
> IS_RUSH_ORDER, OH.INTERNAL_CODE AS INTERNAL_CODE, OH.REMAINING_SUB_TOTAL AS
> REMAINING_SUB_TOTAL, OH.GRAND_TOTAL AS GRAND_TOTAL, OH.PROM_TYPE AS
> PROM_TYPE, OH.WEAR_DATE AS WEAR_DATE, OH.GRAD_DATE AS GRAD_DATE,
> OH.LINK_SHARE_SITE_ID AS LINK_SHARE_SITE_ID, PM.GL_ACCOUNT_ID AS
> GL_ACCOUNT_ID, PM.DESCRIPTION AS DESCRIPTION, PM.FROM_DATE AS FROM_DATE,
> PM.THRU_DATE AS THRU_DATE, PE.SALUTATION AS SALUTATION, PE.FIRST_NAME AS
> FIRST_NAME, PE.MIDDLE_NAME AS MIDDLE_NAME, PE.LAST_NAME AS LAST_NAME,
> PE.PERSONAL_TITLE AS PERSONAL_TITLE, PE.SUFFIX AS SUFFIX, PE.NICKNAME AS
> NICKNAME, PE.FIRST_NAME_LOCAL AS FIRST_NAME_LOCAL, PE.LAST_NAME_LOCAL AS
> LAST_NAME_LOCAL, PE.MEMBER_ID AS MEMBER_ID, PE.GENDER AS GENDER,
> PE.BIRTH_DATE AS BIRTH_DATE, PE.HEIGHT AS HEIGHT, PE.WEIGHT AS WEIGHT,
> PE.MOTHERS_MAIDEN_NAME AS MOTHERS_MAIDEN_NAME, PE.MARITAL_STATUS AS
> MARITAL_STATUS, PE.SOCIAL_SECURITY_NUMBER AS SOCIAL_SECURITY_NUMBER,
> PE.PASSPORT_NUMBER AS PASSPORT_NUMBER, PE.PASSPORT_EXPIRE_DATE AS
> PASSPORT_EXPIRE_DATE, PE.TOTAL_YEARS_WORK_EXPERIENCE AS
> TOTAL_YEARS_WORK_EXPERIENCE, PE.COMMENTS AS COMMENTS,
> PE.EMPLOYMENT_STATUS_ENUM_ID AS EMPLOYMENT_STATUS_ENUM_ID,
> PE.RESIDENCE_STATUS_ENUM_ID AS RESIDENCE_STATUS_ENUM_ID, PE.OCCUPATION AS
> OCCUPATION, PE.YEARS_WITH_EMPLOYER AS YEARS_WITH_EMPLOYER,
> PE.MONTHS_WITH_EMPLOYER AS MONTHS_WITH_EMPLOYER, PE.DATE_OF_EVENT AS
> DATE_OF_EVENT, PE.EVENT_TYPE AS EVENT_TYPE, PE.GRADUATION_YEAR AS
> GRADUATION_YEAR, OCM.CONTACT_MECH_PURPOSE_TYPE_ID AS
> CONTACT_MECH_PURPOSE_TYPE_ID FROM ((((dbo.PAYMENT_METHOD PM INNER JOIN
> dbo.ORDER_ROLE ORR ON PM.PARTY_ID = ORR.PARTY_ID) INNER JOIN
> dbo.ORDER_CONTACT_MECH OCM ON ORR.ORDER_ID = OCM.ORDER_ID) INNER JOIN
> dbo.POSTAL_ADDRESS PA ON OCM.CONTACT_MECH_ID = PA.CONTACT_MECH_ID) INNER
> JOIN dbo.PERSON PE ON ORR.PARTY_ID = PE.PARTY_ID) INNER JOIN
> dbo.ORDER_HEADER OH ON ORR.ORDER_ID = OH.ORDER_ID, dbo.CREDIT_CARD CC (*Could
> not allocate space for object 'dbo.CWT'.'CWT_PrimaryKey' in database
> 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by
> deleting unneeded files, dropping objects in the filegroup, adding
> additional files to the filegroup, or setting autogrowth on for existing
> files in the filegroup.)
> *
>
> I wanted to ask that is the problem is related with
>
> 1)  JVM heap size that set as        low 256m   high 512m
> OR
> 2) with the physical memory of the datase drive   as my drive have a little
> free space left
>
> are both the reasons ??
> what's the sol??
>
> Please Help
>

[jaiser roney]

Thanx BJ  but
From where can i set the autogrow on ??
Could you please make it more clear

[Scott Gray]

It is most likely the space on the hard drive considering the content of the
error message, why don't you try clearing some space and see if that solves
the problem.

Regards
Scott

On 18/11/2007, jaiser roney <[hidden email]> wrote:
>
> Thanx BJ  but
> From where can i set the autogrow on ??
> Could you please make it more clear
>

[BJ Freeman]

http://support.microsoft.com/kb/822641

jaiser roney sent the following on 11/17/2007 8:19 PM:
> Thanx BJ  but
>>From where can i set the autogrow on ??
> Could you please make it more clear
>