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
